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