Monday, 20 September 2010

'Property Owner is not available for Database' Error Message in SQL Management Studio

When trying to open the properties for a database in SQL Management Studio, you may encounter a message that states 'Property Owner is not available for Database'

This can happen on restored databases. To solve this, adjust the below query;

USE SampleDB
EXEC sp_changedbowner 'DOMAINNAME\USERNAME'

2 comments:

  1. This does not work for me i only get this error

    Msg 911, Level 16, State 1, Line 1
    Could not locate entry in sysdatabases for database 'SharePoint_AdminContent_d4e397f2'. No entry found with that name. Make sure that the name is entered correctly

    ReplyDelete
  2. if you can help please do on this thread http://social.microsoft.com/Forums/en-US/partnerwinserversbs/thread/8b125412-3793-449b-9e8b-6501a29f6a70

    ReplyDelete