vineet_dubey1975 (2/7/2014)
I initially thought of this solution but on production database , SQL Server won't allow me to drop the Origanal table as this might be accessed by some user at that point.
So put the drop in a loop, with the rename in the same transaction.
I've used the drop and rename technique for whole databases, as well as for individual tables, in active production systems, and never had a problem.
Tom