posts - 48, comments - 16, trackbacks - 4

My Links

Archives

Post Categories

Web Dev

Property Owner is not available for Database

 

TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)
------------------------------
Property Owner is not available for Database '[dbname]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Owner&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

 

 

To fix simply change the owner, for example:

use dbname

exec sp_changedbowner 'sa'

 

 

 

 

Print | posted on Friday, June 06, 2008 1:42 PM | Filed Under [ Web Programming ]

kick it on DotNetKicks.com

Feedback

No comments posted yet.

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 7 and 6 and type the answer here:

Powered by: