Just a quick note on how Denali creates #temp tables, as the behavior has changed slightly from previous versions, and could potentially break your existing scripts. You may be familiar with this syntax for checking for the existence of #temp tables: IF OBJECT_ID('tempdb..#foo') > 0    -- do somethingThis always worked in ...