Post reply

How to find out the actual user who is running the script on a sql server?

  • July 17, 2010 at 8:48 am

    #237790

    Hi,

    I have strange problem. I wanted to find out the who is running the scripts from the application.

    When I run a trace it just returns the windows group user belongs to. I am sure there is an easy way to find out. Please help!!!. It is very urgent.

    Running SQL 2000 sp4 and application server connects to db server to execute the queries.

    example: username xyz\user1 belongs to xyz\dbwriter. when xyz\user1 execute a script it returns xyz\dbwriter on my trace which is not good. i wanted to who actually run the script.

    thanks,

    Vas

  • July 20, 2010 at 9:13 am

    #1195608

    Cant you try to use Host_Name to find out based on who sits on that work station?

    -Roy

  • July 20, 2010 at 9:59 am

    #1195651

    Thanks for your suggestion. Application is being accessed from a Citrix server. Tt is returning same host_name for most of the users.

    Any other ideas please??

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

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