September 9, 2008 at 8:36 am
I am trying to identify the issuer of a query on our third party system. The query is causing a lock. In the old days of Windows Forms apps the Pc name could be determined via the SP_WHO2 SP under hostname, but with this web based application all I get is the name of the server it is hosted on. Is there anyway I can trace it back, maybe through IIS ?to determine the PC that this is issued from?
The application is a third party app and any changes to the source code take a very long time. So it cannot be done this way.
September 9, 2008 at 8:50 am
You can use the profiler to identify. You just have to add the Hostname to you list of columns to be displayed. You can also just specify a condition to catch just he call of that particular stored proc.
It will be in the TextData Filter. You can choose the Like option that is provided. Give the value as %StoredProcName%
Roy
-Roy
September 9, 2008 at 8:58 am
Just tried this but I only seem to get the IIS Servername rather than the PC name, the same as I get when I do SP_WHO2. Is it possible to get the PC Name ?
September 9, 2008 at 9:08 am
Is this stored proc Called from a Web site? I did not understand your question. If so, You can look in the IIS log to see who called that report by checking the IP. That should point you to the source.
-Roy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply