Unable to see the database properties. Getting the below error. I have the dbowner rights set as 'sa'

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  May 12, 2015 at 10:51 am

  #300622

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  Cannot show requested dialog.

  ------------------------------

  ADDITIONAL INFORMATION:

  Cannot show requested dialog. (SqlMgmt)

  ------------------------------

  Property Size is not available for Database '[DB01]'. 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=11.0.5058.0+((SQL11_PCU_Main).140514-1820+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Size&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738683

  More actions

  May 12, 2015 at 2:33 pm

  #1797385

  Are you sa or db_owner? These are separate things. If you are sa/sysadmin, you have rights. If you are the db_owner, then you can see properties.