>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