Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning How to Disable an index in sql server 2000 RE: How to Disable an index in sql server 2000

  • April 18, 2008 at 12:08 am

    #804103

    Anirban Paul (4/17/2008)

    Check this whether it works or not:

    ALTER INDEX [IX_name] ON table DISABLE

    GO

    Alter Index is only 2005 and higher. 2000 didn't have the command at all.

    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