In addition, I recommend you make a backup of the table as a precaution.
I would go to the extent of scripting out the table, including indexes and Key relationships.
Then a simple select * into tablebackup12212009 from table would suffice for the backup.
Doing this provides a bit of protection should something happen during the conversion. This has saved me from catastrophy due to a transaction deadlock on the table rebuild that killed the temp table and the data in it. If not for the backup, I would have been hosed.
Other than that, do as Lowell recommends.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events