Mountain Steve (1/7/2014)
I keep having a long running profile shut down because the C Drive is full. I am saving the output to a table so is there a method to stop the direction to the screen?
Use a serverside trace. You initiate it via T-SQL instead of via the profiler.
Offhand, not sure about the rest.
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