Tech Off Thread

4 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

Trying to view Database properties gives error in SQL 2005

Back to Forum: Tech Off
  • User profile image
    qwert231

    I right click on my database and get this message:
    Cannot show requested dialog.
    Property Owner isn ot available for Database '[xxx]'. This property may not exist for this object, or may not be retreivable due to insufficient access rights.

    I'm logged in as the Administrator for the machine, and connect to the SQL server (local) using Windows Authentication.
    How can I fix it?

  • User profile image
    pedinopa

    Does anyone know a fix for this?

  • User profile image
    pedinopa

    found the answer, I had to run an SQL script to give ownersship to 'sa'

     

    here is the script

    USE <DatabaseName>
    GO

    EXEC sp_changedbowner ‘sa’

  • User profile image
    qwert231

    Awesome!
    Worked!
    Sweet!
    Thanks!

    Now I'm getting somewhere.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.