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.



thanks


Jim