Microsoft SQL Server 2005: Property Owner is not available for Database xxxxx
I restored a backup over a fresh MS SQl 2005 instance recently.
I tried to open the properties dialog from the Management Studio/Object Explorer for the restored database and got the following message
Property Owner is not available for Database 'db_name'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
Fortunately, I solved my problem by executing the following query against the restored database:
sp_changedbowner sa
No comments:
Post a Comment