• Check this whether it works or not:

    ALTER INDEX [IX_name] ON table DISABLE

    GO

    I don't have 2000 so I can't test it but found this solution in 2-3 sites.

    Hope it works.:)

    Also read these articles:

    http://blog.sqlauthority.com/2007/05/17/sql-server-disable-index-enable-index-alter-index/

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspX