Post reply

question about Profiler

  • January 26, 2006 at 12:24 pm

    #170306

    I'm used Profiler to capture 1 hour's worth of queries on a particular database. The LoginName I'm seeing is almost always a certain SQL login used by one of the applications we have.

    Is there a way to find which pc or IP address is querying SQL Server? There's no other identifying info in the profiler trace data.

  • January 26, 2006 at 12:36 pm

    #617299

    Hello Greg,

    To identify which hostname is using the SQL Server, you need to select the "HostName" under the Data Columns (3rd Tab). This information will be trapped if and only if the client application is providing it.

    Thanks and have a nice day!!!


    Lucky

  • January 26, 2006 at 12:46 pm

    #617300

    Yes, I forgot about that field, and it is populated for the most part for the trace I'm running now.

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply