database session duration
Posted on 2005-04-28
It is said that temporary tables created in a script exist for the duration of the session. Lets say you type some commands in the query analyzer, and run the query.
The session must start when you press the run button, and the session must end when the last command of the script has been implemented, no?
Because when I run the following:
Select * Into MyNewTempTable from dbo.Persons
I do not see any temporary table created in tempdb...so I take it that it is created then deleted?
What exactly is a session?