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'
This does not work for me i only get this error
ReplyDeleteMsg 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
if you can help please do on this thread http://social.microsoft.com/Forums/en-US/partnerwinserversbs/thread/8b125412-3793-449b-9e8b-6501a29f6a70
ReplyDelete