Stored Procedure for dropping indexes
Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops.
Then I would like another strored procedure that takes a table name as input and puts back all the indexes that were dropped.
We need to load 1 to 3 million rows a night and we manually drop all the indexes and put them back after the load. Is this something that can be written as a stored procedure?



