Database diagram cannot be installed
如查你在SQL2005中建立数据库图表时出现以下错误:
"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."
他的解决办法:
EXEC sp_dbcmptlevel '数据库名', '90';
go
ALTER AUTHORIZATION ON DATABASE::数据库名TO "登录数据名"
go
use [数据库名]
go
EXECUTE AS USER = N'dbo' REVERT
go
"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."
他的解决办法:
EXEC sp_dbcmptlevel '数据库名', '90';
go
ALTER AUTHORIZATION ON DATABASE::数据库名TO "登录数据名"
go
use [数据库名]
go
EXECUTE AS USER = N'dbo' REVERT
go
浙公网安备 33010602011771号