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.