SQL Server Performance

Sql database tables monitoring

Discussion in 'General Developer Questions' started by tariqkhan, May 8, 2008.

  1. tariqkhan New Member

    I have set up trigger on my database tables. To record Audit for the tables.
    Now i want to check who which user have made changes to those tables.
    From the Querry analyzer if insert values in tables and in the trigger i can get the user information by using sp_who @@SPID.
    i have the small vb.net user application and wants to track the changes made to the table from vb.net.
    How can i get the user of vb.net in trigger.
    tariqkhan, May 8, 2008
    #2

  2. MohammedU New Member

    Check CURRENT_USER, SESSION_USER and SYSTEM_USER fuctions in BOL...
    MohammedU, May 8, 2008
    #3

  3. satya Moderator

    Welcome to the forum!
    Post the question in relevant forum section only, moved from DB Mirroring section.
    satya, May 9, 2008
    #4

Share This Page