>>>No, I didn't see a call to my SP
>>>Yes, I used the default template
>>
>>Do you have batch completed and procedure completed events? These are the only two you need. If you don't see calls to your SP after you run the trace, then your SP is not called.
>
>Then why is it saying that it can't find the SP on the 2nd time through? I do see connection_resets being called in the trace and the only SP I see being called is some generic getbatchid proc.
Post a screen shot of your profiler trace.
Also, try placing a break point on the SQLEXEC line and see if anything is shown in the trace after you click on it.
If it's not broken, fix it until it is.
My Blog