September 29, 2010 at 7:39 pm
Hi,
When I go on my production server -->database, right click, properties, it gives an error:
cannot show requested dialog.
Property owner is not available for database 'XYZ'. This property may not exist for this object, or may not be retrievable due to insufficient rights.
I am using sa and have all rights.
Other databases I can see the properties but only two of them are giving these errors.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 29, 2010 at 8:45 pm
Are you getting the same for all databases or just a single one.
Can you try firing sp_helpdb and check whether something is unusual for this database?
Regards,
Raj
September 30, 2010 at 12:23 am
Run sp_helpdb and you would notice that the Database Owner for that database is NULL. Running sp_changedbowner 'OwnerName' would fix this issue. I had a similar issue and posted about it here[/url]
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 30, 2010 at 12:28 pm
@ nagaraj
Just for 2 databases...
sp_helpdb shows that the owner for those databases is null
@Adiga..
Ya, the owner of those databases is NULL....
Can i change the ownername of those databases from NULL to 'sa' ?
Its a production server and many users are using it , so will it affect the users or not?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 30, 2010 at 12:35 pm
Even with the NULL owner if the application is working fine, then changing it sa should not have any impact
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 30, 2010 at 12:53 pm
I agree, The database owner change should have no effect on people using the database if it has not had any effort so far.
September 30, 2010 at 3:22 pm
@ pradeep and steve
Thanks a lot
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply