I am trying to attach to the SQL Server 2000 sample Northwind database using SQL Server 2005. When I do the Database-->Attach using the GUI everything seems alright. I can open the Northwind database and see the usual listing of stuff.
However, when I click on the Database Diagrams, I get an error message stating "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 support objects."
I have tried repeatedly to get the ALTER AUTHORIZATION statement to work, all to no avail. I have restarted my machine, and the properties of the database is now saying that the owner is the same as the other databases I have, but I keep getting the error message.
What am I doing wrong here? How can I fix this?Any help would be greatly appreciated.
Thank you.Did you already checked the link: http://msdn2.microsoft.com/en-us/library/ms186345.aspx
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
That worked perfectly.
Thank you!
No comments:
Post a Comment