Property Owner is not available for Database


TITLE: Microsoft SQL Server Management Studio
——————————

Cannot show requested dialog. (SqlMgmt)

Property Owner is not available for Database ‘[test]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo).

Solution: Open New Query windows in SQL Server Management Studio, and execute check for

sp_helpdb

it will shows a list of db name, db size, owner [Unknown] you should  change db owner from Unknown to your SQL Server Login, you can execute

sp_changedbowner @loginame =’sqladmin’

004 Error Property Owner is not available for Database

Advertisements

About Buja Atdhe

CEO of the platform
Gallery | This entry was posted in Error directory, Technical descriptions and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s