Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Error in Sql Server 2008
Add to briefcase

Error in Sql Server 2008 Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
OnlyOneRJ
Posted Wednesday, January 23, 2013 3:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 7:31 AM
Points: 165, Visits: 463
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
Gazareth
Posted Wednesday, January 23, 2013 3:43 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, June 10, 2013 4:11 AM
Points: 1,474, Visits: 2,344
I think the database owner is an invalid login - check in sys.databases.
If so, you can change it using ALTER AUTHORIZATION.
Post #1410449
Bhuvnesh
Posted Wednesday, January 23, 2013 3:52 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453
For example:

USE SampleDB
EXEC sp_changedbowner 'sa'

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #1410453
GilaMonster
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: Today @ 12:31 PM
Points: 38,091, Visits: 30,384
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
OnlyOneRJ
Posted Wednesday, January 23, 2013 6:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 7:31 AM
Points: 165, Visits: 463
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.