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'

0 comments:

Post a Comment