Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error in Sql Server 2008 Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 3:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
When ever i am trying to view the properties of the Database, below error occurs everytime..


{

Cannot Show requested dialog.

Additional Information
Cannot show requested dialog. (sqlMgmt)
Propert owner is not available for Database '[XYZ]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

}

Although i have sys admin access.. still this problem









************************************
Every Dog has a Tail !!!!!
Post #1410434
Posted Wednesday, January 23, 2013 3:43 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:10 AM
Points: 1,976, Visits: 3,337
I think the database owner is an invalid login - check in sys.databases.
If so, you can change it using ALTER AUTHORIZATION.
Post #1410449
Posted Wednesday, January 23, 2013 3:52 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:01 AM
Points: 2,840, Visits: 3,968
For example:

USE SampleDB
EXEC sp_changedbowner 'sa'



-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1410453
Posted Wednesday, January 23, 2013 6:23 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 5:09 PM
Points: 39,968, Visits: 36,327
sp_changedbowner:
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER AUTHORIZATION instead.


ie, as Gazareth said, ALTER AUTHORIZATION ON <database name> TO <login name>



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1410529
Posted Wednesday, January 23, 2013 6:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
thanks All, yes the DB owner was NULL.. i have changed that with
sp_changedbowner 'username'

thanks All...








************************************
Every Dog has a Tail !!!!!
Post #1410533
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse