adonetok (1/16/2014)
Because I need test scripts in which there are a lot of temp tables. I need to modify codes or parameters to run more thank one time. If I do not delete temp tables, errors will occur.
Unfortunately, there's no bulk code for it.
Best thing you can do is just search the proc for CREATE TABLE # and then setup a bunch of if exists/drop at the top of the script.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA