Community

Local vs Global SQL Server Temporary Tables

(Rick Dobson) Temp tables are temporary in the sense that they exist for as long as the database connection which created and populated them exists. After the connection is closed, the temp table drops from SQL Server.