Post reply

Delete statistics option is disabled when you try to delete statistics in sql server

  • October 29, 2013 at 11:29 pm

    #285460

    Delete statistics option is disabled when you try to delete statistics in sql server 2008 r2. Please guide how to delete it

  • October 29, 2013 at 11:53 pm

    #1662613

    Is it system statistics?

    I beleive it can be dropped by DROP STATISTICS [dbo].[tablename].[statsname] command.

  • October 30, 2013 at 12:45 am

    #1662617

    Are you looking at stats associated with an index? Those can only be dropped by dropping the index. Otherwise the drop stats option should work. Otherwise the DROP STATISTICS statement

    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

  • November 1, 2013 at 2:27 pm

    #1663605

    Smash125 (10/29/2013)

    Delete statistics option is disabled when you try to delete statistics in sql server 2008 r2. Please guide how to delete it

    I believe it's not possible through GUI. You need to use DROP STATISTICS as Gail mentioned.

Viewing 4 posts - 1 through 3 (of 3 total)

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