When I try to check the properties of the AdventureWorks database from SSMS. I couldn't able to see the properties of the database and i got below error.
Property Owner is not available for Database 'AdventureWorks'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
To solve above error I had changed the database owner using below stored procedure.
USE AdventureWorks
GO
EXEC sp_changedbowner 'sa'
GO
No comments:
Post a Comment