• I don't think a global temp table would necessarily be immediately dropped. But overall I agree, there's no great concern to drop temp tables in the code, unless perhaps:

    1) you have a very large number of temp tables; and/or

    2) the temp tables are (very) large; and/or

    3) you have a very long amount of processing to do later in the same proc.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.