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.