Disable logging

is there a option to disable logging during alter column
scripts...?
what are the events can be disabled from logging...?What exactly is your ALTER table command like? Can you post it here?
Generally, when you run an ALTER TABLE...ALTER COLUMN on a column, SQL
Server updates that column, to make sure the new column datatype is
compatible with the current data, and this results in logging. You cannot
disable transaction logging.
Your other alternative, could be adding a new column and updating the new
column with the old columns values, in smaller batches. Once the new column
is populated, drop the old column and rename the new.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:6cf901c4837c$609aaf30$a601280a@.phx.gbl...
is there a option to disable logging during alter column
scripts...?
what are the events can be disabled from logging...?|||> what are the events can be disabled from logging...?
SELECT INTO and other bulk operations are minimally logged in the SIMPLE or
BULK LOGGED recovery model. To provide ALTER TABLE functionality, you can
create and load a new table using one of these techniques and then drop the
old table and recreate constraints and indexes.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:6cf901c4837c$609aaf30$a601280a@.phx.gbl...
> is there a option to disable logging during alter column
> scripts...?
> what are the events can be disabled from logging...?