November 12, 2016 at 10:24 am
Hi guys,
I'm new to SQL and need a bit help here. I'm troubleshooting an application (no source code). I set up SQL profiler and captured RPC call something like RPC compeleted EXEC my_storedProc @paramater = '12345'
I believe value '12345' was generated by one of the stored proc, is there anyway to trace it where it is from?
thanks a lot!
November 12, 2016 at 11:22 am
weiran1982 (11/12/2016)
Hi guys,I'm new to SQL and need a bit help here. I'm troubleshooting an application (no source code). I set up SQL profiler and captured RPC call something like RPC compeleted EXEC my_storedProc @paramater = '12345'
I believe value '12345' was generated by one of the stored proc, is there anyway to trace it where it is from?
thanks a lot!
Kind of. Be sure to include the host name and user names in the trace to help you determine where the whole shebang is being called from. Also be sure to include the TextData column so that you can actually see the code for each line of output.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply