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 26, 2017 at 6:03 am

    #1973405

    Thom A - Tuesday, December 26, 2017 5:58 AM

    The column's value won't revert on its own, which either means someone is performing a restore on the database (which would revert everything) or someone or something is running an UPDATE, or DELETE and INSERT, statement that sets the value to a value that is the same as it was before.

    This could be a transaction that is hitting a rollback instead of a commit. If a trigger is set up, it might be helpful to add an @TRANCOUNT to see if a transaction is active.

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/