Database diagram support objects cannot be installed
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
go
ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
go
use [yourDB]
go
EXECUTE AS USER = N'dbo' REVERT
go
TrackBacks
There are no trackbacks for this entry.
Trackback URL for this entry:
http://www.robgonda.com/blog/trackback.cfm?975501BD-3048-7431-E441EE7B633F611E
http://www.robgonda.com/blog/trackback.cfm?975501BD-3048-7431-E441EE7B633F611E
This was a database that was created with SQL 2000, detached, and then attached to SQL 2005, by the way...
1. Right Click your database and select ‘Properties’ at the bottom of the list.
2. Click the ‘Options’ item on the left of the ‘Database Properties’ dialogue.
3. Select the correct ‘Compatibility level’ in the drop down list.
Hope this helps.
Thanks.
Mike
<a href='http://jordan.broughs.net>Jordan Brough</a>
thanks
thanks