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

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: