>Try this (though it won't work if you disable a clustered index and then try to insert data....so I'd only recommend this for reading data)
>
>

>ALTER INDEX  [MyIndex] on [MyTable] DISABLE
> GO
>-- do your stuff
>
>ALTER INDEX  [MyIndex] on [MyTable] REBUILD
>
> GO
>

>
>I'm not aware of any way to re-enable an index...only way I know is to rebuild it.

This works. However, it will just keep bouncing back on other indexes until I disable them all. Is there a way to disable all the indexes on a table?