Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    20

    Question Unanswered: Database Diagrams Problem....

    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..

  2. #2
    Join Date
    May 2002
    Posts
    299
    Try:

    exec sp_changedbowner 'sa'
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •