>I will read.
>
>In query analyer, when I create a #test table, then insert some data. When insert is running, open another window run 'dbcc opentrans('tempdb'). I got that result.
If you want actual user name, use SP_WHO with the SPID from the 'dbcc opentrans('tempdb').
--sb--