• 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