Hi all,
I am trying to make DATABASE DIAGRAMs...I have restored a database called Tel from a backup file...n in that i have all the tables and procedures..now whenever i m clicking on its DATABASE DIAGRAMS it gives me the error as:
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.
----------
so,what should i do??any suggestion will be helpful for me...thnks in advance...
regards..Try:
exec sp_changedbowner 'sa'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment