Log Excess

Hi All,
Just wondering if someone can help me, it may sounds like a
silly question but I will ask anyway.
I have a stored procedure that uses a lot of temp tables
and when, the procedure is running eventually my tempdb log
file eats all the room on my drive, if I change the temp
tables to be normal non temp tables, will this stop this
from happening.
Thanks for any help.
PhilThen the same amount (a bit more actually) of log space will be used from
inside your application database instead of tempdb. Perhaps you can look at
the logic and see if you can streamline the process?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Phil" <harlequintp@.blazemail.com> wrote in message
news:12c6c01c4117b$79d3a6a0$a101280a@.phx
.gbl...
> Hi All,
> Just wondering if someone can help me, it may sounds like a
> silly question but I will ask anyway.
> I have a stored procedure that uses a lot of temp tables
> and when, the procedure is running eventually my tempdb log
> file eats all the room on my drive, if I change the temp
> tables to be normal non temp tables, will this stop this
> from happening.
> Thanks for any help.
> Phil