We have a stored procedure that uses temp tables and must gather a lot of data. When we stress test this stored procedure, the tempdb transaction log fills up.

We tried using "Select Into" for our tables. That caused us not to write to the transaction log but it caused problems because it locked up sysobjects.

Is there some other way not to write to the transaction log?

Thanks!

-- Anonymous, August 02, 2001

Answers

Jim,

If you are using SQL Server 7, try setting the trunc. log on chkpt. option for tempdb. If you are using SQL Server 2000, set the Recovery Model to Simple.

Hope this helps,

Eric

-- Anonymous, August 21, 2001