find who created temp table

• Sam Greene

  SSCertifiable

  Points: 5252

  More actions

  September 24, 2008 at 1:13 pm

  #123745

  HI,

  I see many temp tables in my tempdb. Named like #78EUUDLN. Are these system tables? Normally I've seen Temp_____________________________________84958499 type names.

  We're having problems with connection pooling creep and I'm looking for evidence to find the culprit.

  thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  September 24, 2008 at 4:52 pm

  #876730

  It would be helpful if you turn on profiler and catch the code running against your server for temp tables creation and .....

  MJ