>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?
I'm not aware of any one single command. Only way I know is to iterate through a list of indexes and disable using dynamic sql.
The code sample about halfway down the page on this link has an example. I wish I knew of a better way with a simple command, but I don't know of one.
http://stackoverflow.com/questions/2518125/disable-all-non-clustered-indexes