Posted by Dave on 11/15/05 19:45

I detached a SLQ 2000 database and reattached it in 2005 Developers.
When I try to access the Diagrams, the below message is received. My
domain account is owner. I'm local Admin on my machine. Shouldn't be
a problem right? How do I add the Database Diagram Support Objects?



TITLE: Microsoft SQL Server Management Studio
------------------------------

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.

------------------------------
BUTTONS:

OK
------------------------------

• Next in forum: SQL 2005 Unhandled Exception Error
• Prev in forum: Re: flexible back-end data handling in .net + sql project
• Thread view: SQL 2005 Developers Diagram question

[Reply to this message]