title: Deleting Global Temporary Tables (##tempTable) in SQL Server
body: <p>Does SQL server automatically purge these out after a given length of inactivity or do I need to worry about purging them automatically?  If so, how do I query for a list of tables to purge?</p>