如何获取当前的sproc会话ID并删除该sproc实例中存在的临时表？

I'm using sql2000 and I want to automatically drop a #temp table in a sproc instance or in a query window. This is more for testing purposes than production. Is there a way to get the current session or sproc instance or even a query instance, and use that to delete only #temp tables in that instance. I don't want to drop #temp tables in other instances.I'm using sql2000 and I want to automatically d