Post reply

Know the Modifier's Login

  • August 17, 2013 at 10:38 pm

    #282109

    Dear,

    I have done modifications in a table directly from Edit mode of SQL Server. Now is it possible to know the which login is used to done the modifications.

    Please help me to know it.

    Regards,

    Akbar

  • August 17, 2013 at 11:18 pm

    #1642465

    You would need a trigger and, probably, the ORIGINAL_LOGIN() function to capture the login of the person making the direct changes.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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