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

    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 and I want create a profiler trace that can catch or calling sp_storedprocedure. Any suggestion is great appreciated.



  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    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
    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
    Provided Answers: 17
    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