What database does SQL Server use for temporary tables?
Ankur Jain
temporary tables has scope within same session
For storing the data for certain time(until useful), TempDB.
TempDB.