Blog Pages

Property Owner is not available for Database

Error message:
Property Owner is not available for Database '[...]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

Explanation:
For some reason, the owner of the DB was set to 'UNKNOWN'.
Check it using sp_helpdb:


Solution:
Change the DB owner to a valid login, using sp_changedbowner.

USE DBNAME
GO
sp_changedbowner 'sa'
GO

No comments:

Post a Comment