ERROR MESAGGE:
“Property Owner is not available for Database ‘[database_name]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)”
EXPLANATION:
For example, you may see this error message when you try to look at the properties of a database in SQL Server Management Studio. The reason is that the original owner of the database is changed.
SOLUTION:
As the owner of the database, you can assign the user “sa” as follows.
|
1 2 3 |
USE GO EXEC sp_changedbowner 'sa' |
