SQL Server Temp Table Persistence - STORED PROCEDURES
Discussion of Temporary Tables, Persistence and STORED PROCEDURES. Temp Tables are created in the tempdb system database in SQL Server. They are persistent but not necessarily long lived, particularly when executing a store procedure that has its own unique connection to SQL Server. Temp tables are created with strange looking table names that are actually unique instances of the hash mark named table that are related via the specific connection to SQL Server, whether it be through a query window or a stored procedure.
