Drop All Temp Tables For Connection

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

SSC Guru

Points: 76202

November 5, 2015 at 6:17 am

Thanks for this script.

M. Douglas Bowan SSC-Addicted Points: 459 More actions · Answer 2

SSC-Addicted

Points: 459

November 10, 2015 at 6:09 pm

You are welcome.

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 3

It does not drop the temp tables. Still there!

Thanks.

M. Douglas Bowan SSC-Addicted Points: 459 More actions · Answer 4

This is most curious.

I have been using this for quite a while.

What MS SQL Server version are you using?

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 5

SSC-Dedicated

Points: 33518

May 28, 2016 at 11:30 pm

2014

Thanks.

M. Douglas Bowan SSC-Addicted Points: 459 More actions · Answer 6

Me too, have been running this on SQL 2008R2 - 2014.

Only issue I have seen is if a legacy procedure has been doing a mondo-sized select-into.

The execution just hangs. Other than that, have not heard of any issues before now.

Do you have more information that may help?