Database diagram support objects cannot be installed because this database does not have a valid own
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files pa
·
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects
出现上述问题的原因：是因为你把另外一个服务器上的数据库导出后，对于当前数据库没有兼容好，解决如下：
1。右键点击你的数据库，选择属性
2。转到“选项”
3。在右边标有“兼容级别”的下拉选择“SQL Server 2005中（90）”
4。转到“文件”
5。所有者“文本框中输入”SA“。
6。点击OK
还要执行下列语句：
eg:
EXEC sp_dbcmptlevel 'aa','90';
go
ALTER AUTHORIZATION ON DATABASE::aaTO "sa"
GO
use aa
go
EXECUTE AS USER = N'dbo' REVERT
go
然后就OK了
来源参考：http://geekswithblogs.net/shahed/archive/2007/11/19/116940.aspx
2。转到“选项”
3。在右边标有“兼容级别”的下拉选择“SQL Server 2005中（90）”
4。转到“文件”
5。所有者“文本框中输入”SA“。
6。点击OK
还要执行下列语句：
EXEC sp_dbcmptlevel 'yourDB', '90';
go
ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
go
use [yourDB]
go
EXECUTE AS USER = N'dbo' REVERT
go
eg:
EXEC sp_dbcmptlevel 'aa','90';
go
ALTER AUTHORIZATION ON DATABASE::aaTO "sa"
GO
use aa
go
EXECUTE AS USER = N'dbo' REVERT
go
然后就OK了
来源参考：http://geekswithblogs.net/shahed/archive/2007/11/19/116940.aspx
昇腾计算产业是基于昇腾系列（HUAWEI Ascend）处理器和基础软件构建的全栈 AI计算基础设施、行业应用及服务，https://devpress.csdn.net/organization/setting/general/146749包括昇腾系列处理器、系列硬件、CANN、AI计算框架、应用使能、开发工具链、管理运维工具、行业应用及服务等全产业链
更多推荐
0
0- 0
已为社区贡献1条内容
所有评论(0)