Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: Which event can catch web application name?

    Hello, everyone:

    I want to know if there is an event in profiler can catch web application name. If yes, which one? For example, there is SP named sp_storedprocedure that is called by www.web.com and www.web.com/forumdisplay.php?f=23. I want create a profiler trace that can catch www.web.com or www.web.com/forumdisplay.php?f=23 calling sp_storedprocedure. Any suggestion is great appreciated.

    Thanks

    ZYT

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    The following table describes the Microsoft SQL Server Profiler data columns, which are the same data columns as those used by SQL Trace, and indicates the columns that are selected by default.


    Data column Column number Description ApplicationName 1
    10
    The name of the client application that created the connection to an instance of SQL Server. This column is populated with the values passed by the application and not the name of the program.
    straight from 2005 BOL ... did you think to look there?

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    In order to do this, you would need to set the Application Name parameter of the connection string on each separate web page. This is a bad idea for long term use, since the connections then become distinct, and your connection pool will increase greatly in size.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •