Post reply

Track DML opertion

  • September 10, 2019 at 6:43 am

    #3678688

    Hi Experts,

    one of my table got updated all of a sudden and no one knows how, Is there any way to track the change?

    I have below information in hand.

    • I have restored the database to the time just after the change.
    • I have an SPID which I believe 99% is the culprit.
    • I have the queries with parameters but not exact values.

    Thanks in Advance

  • September 10, 2019 at 4:53 pm

    #3678833

    If there was no type of auditing in place to capture things then you are limited in what you can find. Not sure what you are looking for but transactions are in the log. You can read the log or log backups with the undocumented sys.fn_dblog (current database log) or sys.fn_dump_dblog (log backup). Even though they are undocumented, There are quite a few blog posts about the two if you search on those. But that can help track down what SPID did the changes if that's what you are looking for. Just to add, there is another one added in 2017 (fn_full_dblog) but your on 2014 so it doesn't matter. Figured someone would post about it if I didn't.

    Sue

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

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