Error in Sql Server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Error in Sql Server 2008

Error in Sql Server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

OnlyOneRJ

Posted Wednesday, January 23, 2013 3:11 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

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 w00t

************************************
Every Dog has a Tail !!!!!

Post #1410434

Gazareth

Posted Wednesday, January 23, 2013 3:43 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 1:53 AM
Points: 1,474, Visits: 2,342

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

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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

Group: General Forum Members
Last Login: Today @ 4:16 AM
Points: 37,677, Visits: 29,930

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

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

thanks All, yes the DB owner was NULL.. i have changed that with
sp_changedbowner 'username'

Smile

thanks All...

************************************
Every Dog has a Tail !!!!!

Post #1410533

« Prev Topic | Next Topic »

Permissions