Home Forums SQL Server 2008 SQL Server 2008 - General Track username and time of action on delete for rows RE: Track username and time of action on delete for rows

  • August 26, 2013 at 2:21 pm

    #1644962

    Sean Lange (8/26/2013)

    If however you use windows authentication you might be able to use SUSER_SNAME().

    I would recommend ORIGINAL_LOGIN() instead, in case there's any impersonation occurring.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass