Alter table problems (transaction log will growth to 60 Gb...)

Also, consider creating the new table using SELECT INTO, which is
minimally-logged in the SIMPLE model.

--
Hope this helps.

Dan Guzman
SQL Server MVP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 10th February 17:18 dan guzman External User Posts: 1	Alter table problems (transaction log will growth to 60 Gb...) Also, consider creating the new table using SELECT INTO, which is minimally-logged in the SIMPLE model. -- Hope this helps. Dan Guzman SQL Server MVP