Error:
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
------------------------------
Solution:
1. Right Click on your database, choose properties
2. Goto the Files
3. Change the owner textbox to "sa"
4. Press OK
5. Enjoy
19 comments:
Thanks really helpful.
Hafiz
Nice it works
Thanks !!!
i got this error man but your post helped i changed owner to sa it worked for me thanx
Jap Auto Parts
Thanks a lot it worked like a charm
Gracias!!
before this it was a problem after this it is very easy staff -- thanks
before this it was difficult after this it is too easy --- thanks
before this it was difficult after this it is too easy THANKS
before this it was difficult after this it is too easy THANKS
before this it was difficult after this it is too easy THANKS
before this it was difficult after this it is too easy THANKS
MuchÃsimas gracias, amigo.
It worked. Great.
u r crazy man, i have 2 hour that i am looking and trying to fix that, with ur instructions with 4 hops i have fix that, thank u veryy muchh.
@Be-Bu: YW, This is awesome and You made my day :-)
Thanks, this was a big help
Thanks. It works
Post a Comment