[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Property Owner is not available for Database
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Property Owner is not available for Database.


Applies to: Microsoft SQL Server 2000, Windows Server 2003.



Error Message.

 

Cannot show requested dialog.

Additional information:

Cannot show requested dialog. (SqlMgmt)

Property Owner is not available for Database [     ].  This property may not exist for this object, or may not be retrievable due to insufficient access rights.

(Microsoft.SqlServer.Smo)

 

 

Cause.

The above error happened because the original dbo login of that database was removed recently from the SQL Server 2000 instance.

 

Solution.

Change the owner of the database.


For example:

USE SampleDB
EXEC sp_changedbowner 'sa'
 


 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.