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 11:09 pm

    #1973540

    imran-k - Tuesday, December 26, 2017 6:09 AM

    This table is read by other processes but not get modified only by front end application. The issue is only that date column has this issue and the auto reverting happens hours later each time, not exactly sure how many hours. If it was instant change then it would have been easier to pick up the cause probably. What should I write in the trigger to capture the process?

    Please clarify whether the date field is an epoch or date-time field ? If it is epoch field, check the related Stored Proc update statement in the back end, (dateadd function), Otherwise check the front end application web services update operation onto this epoch / date-time field ? ( how this db table date field getting populated when front end value date field modified by the users)

    You'd as well mentioned this table has been read by other processes, then check anyone from your team / shared services team had been updating the db table manually ( with excel  / csv dump ) post the front end application committed the date value in db table ?