Posted by Simon Hayes on 09/09/05 19:42

"Travis" <Travi424@hotmail.com> wrote in message
news:1126279238.782948.112340@z14g2000cwz.googlegroups.com...
>I have a stored procedure that creates a temp table that is used to
> insert data from a dynamic query. My question is does the logging of
> the insert occur in the local database running the stored procedure or
> does it occur in the tempdb database? My log file for local database
> is growing significantly and I want to rule out that the temp table is
> not writing to the local database log. I have done some testing and it
> appears that is not but I just confirm my findings.
>

An INSERT into the temp table will be logged in tempdb; an INSERT from the
temp table into a permanent table will be logged in that database.

Simon

[Back to original message]