January 23, 2013 at 3:11 am
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 !!!!! :-D
January 23, 2013 at 3:43 am
I think the database owner is an invalid login - check in sys.databases.
If so, you can change it using ALTER AUTHORIZATION.
January 23, 2013 at 3:52 am
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;-)
January 23, 2013 at 6:23 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 23, 2013 at 6:34 am
thanks All, yes the DB owner was NULL.. i have changed that with
sp_changedbowner 'username'
🙂 thanks All...
************************************
Every Dog has a Tail !!!!! :-D
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply