Globle temp table info

• Dhaval-190627

  Old Hand

  Points: 323

  More actions

  January 24, 2005 at 2:52 pm

  #165756

  Where does global temp table get store. I have one procedure which create @@New table and delete this table at the end of proceduer, next time when it run it make sure it globel table get delete and then create againt. Where can i get info about temp globle table.

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  January 24, 2005 at 8:50 pm

  #538872

  Temp tables are stored in tempDB.  Is your table called "@@New table" or "##New Table"?  If it is @@New Table it is a table variable stored in memory.

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor