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 |
|
centra28
Starting Member
8 Posts |
 Posted - 2011-01-19 : 13:05:22
|
| i'm using microsoft visual studios 2008 to create a sql database, and i am getting these messages when trying to create a new database diagram:"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."i chose yes, then get this error box:"Could not obtain information about Windows NT group/use 'SCHOOL\Dale', error code 0x534."What am i doing wrong, or how can i fix this issue? i'm stuck until i can get this resolved. thanks in advance for any help. |
|
|
centra28
Starting Member
8 Posts |
Posted - 2011-01-20 : 12:42:15
|
| bump, still looking for some help on this |
 |
|
|
centra28
Starting Member
8 Posts |
Posted - 2011-01-21 : 11:09:10
|
| still looking for help on this |
|
|
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2011-01-21 : 12:59:43
|
I doubt if you will get much help on SQL's diagrams as third party tools are just so much better.Looking at the error message, you could try changing the owner in management studio with something like the following script:USE YourDBGOEXEC sp_changedbowner 'sa'GO |
|
|
|
centra28
Starting Member
8 Posts |
Posted - 2011-01-21 : 14:50:20
|
| i have tried that once, but i'm not sure what to use as the new owner.. is the it the windows profile name, the domain name, or the computer's name? |
|
|
|
|
|
|
Help w/ creating diagram