Post reply

Right click on a Database, select properties Error, cannot show requested dialog.

  • July 3, 2013 at 6:54 am

    #279475

    I right click on a Database, select properties Error, cannot show requested dialog.

    The error reads:

    cannot show requested dialog (SqlMgmt)

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

    I'm running Database Consistency Checker.

    Has anyone experienced this problem?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 3, 2013 at 6:58 am

    #1629508

    I've seen this in SQL 2005 while running index rebuilds. It would not allow me to see DB properties via GUI, I could query the properties though.

    I'm inclined to think it has something to do with too many locks on the database. Not sure though

  • July 3, 2013 at 9:01 am

    #1629560

    Check that the database owner is set to a valid account. SA is often used.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 17, 2013 at 4:07 am

    #1633164

    Maybe related also to your access rights on the server.

    Cheers! 🙂
    [/url]

  • July 17, 2013 at 4:23 am

    #1633169

    GilaMonster (7/3/2013)

    Check that the database owner is set to a valid account. SA is often used.

    In my experience this is most time the cause of the error. The login of the current database owner is removed/altered and not valid anymore.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • July 17, 2013 at 10:39 am

    #1633381

    I've seen this happen with a funky installation of Management Studio. Try it from another computer.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply