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