We are changing master ID codes for security purposes. And have come upon error messages regarding indexes. We would like disable the indexes, then do the SQL data update, finally rebuild or recreate the indexes.
What's the best way to go about it?
We running SQL 2000 and 2005