Posts
259
Comments
464
Trackbacks
17
February 2006 Entries
FYI: Database Diagrams in SQL Server 2005
I recently restored a SQL Server 2000 database into SQL Server 2005. When I tried to create a database diagram I got the following error:

"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. "

After repeated attempts to to assign a valid login user to the database, I found this thread on the MSDN forums:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112297&SiteID=1

I issued the following command and viola! problem solved:

EXEC sp_dbcmptlevel 'EnterYourDatabaseNameHere', '90';

Just thought I'd share what I found...

Posted On Monday, February 6, 2006 11:14 AM | Comments (15)