Temp Table and Global Temp Table

• sivaprasad

  SSCertifiable

  Points: 6183

  More actions

  November 24, 2003 at 2:09 am

  #81560

  Where the Local Temp table and Global Temp Table will be stored? Is it possible to get the temp. tables scripts? Can anyone explain why it is not visible in Enterprise manager on under tables in Temp DB ?

  Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

• GRN

  Hall of Fame

  Points: 3260

  More actions

  November 24, 2003 at 2:41 am

  #483293

  Where the Local Temp table and Global Temp Table will be stored?

  Tempdb

  Is it possible to get the temp. tables scripts?

  This should check for existance of the tables if you want to check.

  SELECT COUNT(*)

  FROM tempdb..SysObjects

  WHERE Name LIKE '<#TempTable>%'

  this would display the structure

  USE tempdb

  GO

  sp_help <#temptable>

  GO

  Can anyone explain why it is not visible in Enterprise manager on under tables in Temp DB ?

  doesnt make sense showing them if they are temporary !?