I completely agree with Hugo. You said the "best" way, not the way with the least effort (and potentially not the best result). Besides which if you use Query Analyzer (or whatever you people who've moved off sql2000 have) to script the table creation from the original table - which will also script all of the constraints - then the first way is very little effort whatsoever.