Post reply

application username in sql profiler

  • May 3, 2011 at 11:47 pm

    #96202

    hi !

    I want to know if a user login in a application the username or login name can be displayed in sql profiler as system login in sql server or windows lognin.

    if possible how to do

    thanks

  • May 4, 2011 at 6:15 am

    #1319681

    i found you post a bit confusing.actually whosoever is logion into sql server , he/she can be traced by profiler.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • May 4, 2011 at 6:24 am

    #1319685

    deba_20032004 (5/3/2011)

    hi !

    I want to know if a user login in a application the username or login name can be displayed in sql profiler as system login in sql server or windows lognin.

    if possible how to do

    thanks

    Not sure if this is what you mean. If the connection string of your application(s) you can add a parameter for the name of the connecting app.

    This can be customized for each user that connect to include all the ever you ever need about that user.

    then in profiler you'll see that info the application name column. From there on out it,s just string manipulations to filter out the trace.

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

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