Have a procedure with tons of temp tables you don’t want to keep track of?  Or debugging some nasty code with tons of temp tables? This SQL snippet is quite handy.  It will drop all the temp tables in your current scope. Enjoy!