Ok i under stand how to debug with VS, my Question is this. I have an update statement which fires a trigger which in turn fires a stored proc which in turn fires more store procs.... (I did not right this process it was done by a third party.)
The question is i have a suspect SP that i want to put a brake point on but dont want to step through 15-20 other calls, is there a way to have VS break on a given SP.