Dropping all the temporary tables that are created in a seesion

Session-scoped temporary tables created in a stored procedure are automatically dropped at the end of the stored procedure:

A local temporary table created in a stored procedure is dropped automatically when the stored procedure is finished. The table can be referenced by any nested stored procedures executed by the stored procedure that created the table. The table cannot be referenced by the process that called the stored procedure that created the table.

CREATE TABLE

David

---

David http://blogs.msdn.com/b/dbrowne/