Home Forums SQL Server 2012 SQL 2012 - General Want to know what process revert a change of a value in a column RE: Want to know what process revert a change of a value in a column

  • December 27, 2017 at 8:20 pm

    #1973662

    imran-k - Wednesday, December 27, 2017 7:14 PM

    Thanks all for the inputs. The date field is a datetime field. Ok what i had done is created an update trigger which captures suser_sname and app_name and i can confirm that it is not the front end application that is making or reverting the change, the user came out to be as EUMI and app name is Sql server , any ideas what EUMI user is?? No any other physical user is making the change as no one using application due to holidays.Thanks

    Try adding ORIGINAL_LOGIN() to the mix in the trigger to see if someone is doing some sort of "impersonation".  Also check to see if there's an "Active Directory" user in the Windows Domain Controller by that name.  I know of no such name that would come out of SQL Server itself and a quick search on Yabingoolehoo turns up nothing even as an abbreviation except for some very obscure references either for a Korean name of some local government department names.

    --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)