In 2008R2 if I create #Temp in a query or proc when does that table drop it's self or do I need to remember to call the drop command at the end of my work?
-- If I get used to envying others... Those things about my self I pride will slowly fade away. -Stellvia
thats for ## tables (global temporary tables) # table gets destroyed once connection that created it terminates. Also you can have # tables with same name in multiple connections simultaneously
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
for # table, it is created inside a stored procedure, it is destroyed when the stored procedure terminates even if the connection / session is still alive.
When do Temp tabled expire (SQL 2008R2)?
Posted - 10/03/2012 : 19:58:41
