Thanks it works fine in Sql 2008 too.

Why i need this is, i have a long procedure which has multiple temp tables finally i need to drop those tables.

So i...