GilaMonster (4/18/2008)
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.
As I told you I couldn't check as I found in under SQL Server 2000 in some sites. I never used it when I was using SQL Server 2000. I used to drop indexes. So when I saw in sites I thought let me put it in the forum to clear my doubts. Thanks Gail for your comment.
:):)