If you ever get a message like this when trying to create a diagram in SQL 2005
"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."
Here's step by step what you have to do:
EXEC sp_dbcmptlevel 'yourDB', '90'; go ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin" go use [yourDB] go EXECUTE AS USER = N'dbo' REVERT go |
Refered from http://www.robgonda.com/blog/index.cfm/2006/10/29/Database-diagram-support-objects-cannot-be-installed
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8585387/viewspace-231045/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8585387/viewspace-231045/