Archive

Archive for April 16, 2013

Property Size is not available for Database ‘DBNAME’. This property may not exist for this object

April 16, 2013 2 comments

Roscoe .. i will ask again .. let go !! ... Hi...

recently i wanted to change the recovery model of a DB to simple recovery model VIA GUI ..

as i right clicked the Database –> property  .. i received a strange error as below ..

TITLE: Microsoft SQL Server Management Studio

——————————

Cannot show requested dialog.

——————————
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

——————————

Property Size is not available for Database ‘DBNAME’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1617.0+((KJ_RTM_GDR).110422-1125+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Size&LinkId=20476

——————————
BUTTONS:

OK
——————————

  • i was sysadmin on the sql instance .. so it should not have been related to permission
  • i checked the list of DB on the server with sp_helpdb command and noticed the owner for the concerned DB was set to NULL
  • so i tried assigning the DB ownership to one of the valid logins using below command
  • sp_changedbowner [ @loginame = ] ‘login’
                                 [ , [ @map= ] remap_alias_flag ]

above method resolved the issue and i was able to access the property tab ..

  • other consideration –> i did hear someone receiving similar error when the DB ownership was set to a valid login
  • i will try to post some workaround for the same ..

ENJOY 🙂

  •  
Advertisements