NAVmoble - the pocket-sized ERP
Optimized for Microsoft Dynamics NAV and Windows Mobile powered devices
Optimized for Microsoft Dynamics NAV and Windows Mobile powered devices
Tuesday, July 21, 2009
Thursday, July 16, 2009
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
By Ruslan Trifonov on Thursday, July 16, 2009 0 comments
Labels: Sql Server
Subscribe to:
Posts (Atom)