By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,695 Members | 1,638 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,695 IT Pros & Developers. It's quick & easy.

SQL 2005 Developers Diagram question

P: n/a
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
------------------------------

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I found this SQL Community / As a Question. Hope it helps someone out.

************************************************** **********
In SQL Server Management Studio do the following:

1. Right Click on your database, choose properties
2. Goto the Options Page
3. In the Dropdown at right labeled "Compatibility Level" choose "SQL
Server 2005(90)"
4. Goto the Files Page
5. Enter "sa" in the owner textbox.
6. Hit OK

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.