InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 20:14:12 GMT20http://www.sqlservercentral.com/Forums/Topic1410434-1550-1.aspxthanks All, yes the DB owner was NULL.. i have changed that with sp_changedbowner 'username':-) thanks All...Wed, 23 Jan 2013 06:34:06 GMTOnlyOneRJhttp://www.sqlservercentral.com/Forums/Topic1410434-1550-1.aspxsp_changedbowner:[quote]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.[/quote]ie, as Gazareth said, ALTER AUTHORIZATION ON <database name> TO <login name>Wed, 23 Jan 2013 06:23:35 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1410434-1550-1.aspxFor example:[code="sql"]USE SampleDBEXEC sp_changedbowner 'sa'[/code]Wed, 23 Jan 2013 03:52:34 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1410434-1550-1.aspxI think the database owner is an invalid login - check in sys.databases.If so, you can change it using ALTER AUTHORIZATION.Wed, 23 Jan 2013 03:43:01 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1410434-1550-1.aspxWhen ever i am trying to view the properties of the Database, below error occurs everytime..{Cannot Show requested dialog.Additional InformationCannot show requested dialog. (sqlMgmt)Propert owner is not available for Database '[XYZ]'. This property may not exist for thisobject, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)}Although i have sys admin access.. still this problem :w00t:Wed, 23 Jan 2013 03:11:46 GMTOnlyOneRJ