June 16, 2012 at 7:32 am
Unless the webserver passes something to SQL to identify the originator of the request, you can't in this case. As far as SQL (and hence profiler) is concerned, the connections came from the web server, it has no knowledge whatsoever of what connected to the web server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 16, 2012 at 7:38 am
GilaMonster (6/16/2012)
Unless the webserver passes something to SQL to identify the originator of the request, you can't in this case. As far as SQL (and hence profiler) is concerned, the connections came from the web server, it has no knowledge whatsoever of what connected to the web server.
Thanks a Lot GilaMonster.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply