>Yes, I create the temp table with a single #.
>
>So I guess the session does not end till the app which created the connection ends.
>
>Hmm, I will have to use more DROP TABLEs.
>

IF object_id('tempdb..#TempTable') IS NOT NULL
	DROP TABLE #TicketIDList