What are your db Options, select into /bulk copy and truncate log on check
As far as I know, truncate log is not compatible w/transaction log backups, so
it would need to be re-set after each batch process if you have transaction log
backups being processed.
"RS" <ramludd.hr.lucent.com> wrote in message
> I have a stored procedure where in I process around 2 Million records in a
> table. During this process I do "Select Into", "Insert Into" operations on
> to temp tables. At the end of the Stored Proc execution the .ldf file of the
> database is inflating up to 15GB to 17 GB. I believe all my operations are
> logged into this file. Do I have any options to avoid logging?
> Note: I don't want to do "DBCC SHRINKDATABASE".
> Thanks in advance,
> Please Respond to News Group Only