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

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

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
  1. April 15, 2014 at 9:34 pm

    Coupled by recent press news of Tucson being ranked by
    Business week as the top affordable place to retire in the US, we appear to be
    on the right track for the Tucson Az Home Market.
    Not being able to reduce the price can quite often be the difference between generating the
    sale or not. To get them there you should be handing them
    out to everyone you come into contact with, from your dentist to the clerk at a checkout counter.

  2. Arshpreet
    December 8, 2015 at 3:01 pm

    What if the same thing is happening for the “tempdb” database. we cannot change owner for system databases. Any idea why is it happening and how to avoid it?

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

    Msg 15109, Level 16, State 1, Line 1
    Cannot change the owner of the master, model, tempdb or distribution database.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: