Joe-420121 (12/21/2009)

---

1. The table has only 4 coulmmns, no FK, constrains etc.

2. The table is used 24 hours, and about 2000 users use it all the time.

3. When I use GUI to modify data type to BIGINT, I get timeout error after 3 min.

4. Copy data to tmp table and when all done, and drop the old table and just rename it quicky.

( also I am creating the table in a new file group).

5. The size of table is about 60GB, so I feel SELECT INTO might take more time than SSIS. am I wrong?

Thanks for all your helps...