Post reply

Database Owner

  • November 13, 2006 at 5:04 pm

    #114190

    I have migrated Several SQL Server 2000 Databases to SQL Server 2005. I used the detach/attach method to upgrade to SQL 2005.

    I'm trying to create a Database Diagram but when I expand the Database Diagrams Folder within the Database, it comes up with an error of "You must have a valid Database Owner".

    The Database Owner is sa on the properties page of the Database. What else do I have to do to make the owner sa? SA was the owner of each SQL 2000 Database prior to the upgrade to SQL 2005.

    Kindest Regards,

  • November 13, 2006 at 11:16 pm

    #671498

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10946

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • November 14, 2006 at 4:52 am

    #671557

    Hi,

    So, use the command "exec sp_changedbowner 'sa'"

    Regards,

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply