MS SQL Error "Property owner is not available"
Issue
When trying to access properties for a database in Microsoft SQL Server Management Studio, you get the following error:
Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) Property Owner is not available for Database '[databasename]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
Cause
Owner of the selected database is set to a user other than the sa user.
Solution
- Click on the New Query button
- Copy the following script into the New Query box replacing [databasename] with the name of the database you are working with.
use [databasename]
EXEC sp_changedbowner 'sa'
- Click Execute
Article ID: 454, Created: April 9, 2012 at 3:50 PM, Modified: August 26, 2014 at 9:16 AM