Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
X-Factor
Constraint Violating Yak Guru
392 Posts |
Posted - 2006-12-05 : 06:42:34
|
I get...quote: 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 data diagram support objects
Well the owner is set to 'sa' but I keep getting the same message when I click on the diagrams folder. Any ideas?Cheers, XF. |
|
X-Factor
Constraint Violating Yak Guru
392 Posts |
Posted - 2006-12-05 : 07:33:20
|
Maybe it has something to do with the db being a SQL Server 2000 instance attached to 2005 Management Studio..... |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-05 : 23:44:22
|
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)"and then:ALTER AUTHORIZATION ON DATABASE::dbname TO valid_login its me monty |
|
|
X-Factor
Constraint Violating Yak Guru
392 Posts |
Posted - 2006-12-06 : 07:55:50
|
Thankyou very much indeed. |
|
|
|
|
|