who created which temporary table in the tempdb?

• lotusnotes

  SSC Eights!

  Points: 833

  More actions

  October 9, 2009 at 6:50 am

  #215288

  How can you identify which spid created which temporary table in the tempdb?

  Sounds really simple, but I can't identify how to do it.

  Thanks

• jjtetzlo

  SSCrazy

  Points: 2511

  More actions

  October 9, 2009 at 8:43 am

  #1064117

  Jonathan Kehayias recently wrote about this, it includes a cool script to map temp tables to spids:

  http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/09/29/what-session-created-that-object-in-tempdb.aspx

  - Jeff