Find when a query ran an Update to trace the cause
How can I find when an update statement was generated which modified an order number? We cannot locate where in the application this had occurred. I ran a revoke update on the table and specified column but would like to locate what triggered this last night. If I do not have auditing on SQL Server 2008, is there another way to see when this query was run and what time? I would use SQL Profiler but unfortunately there is no exact time when this happened logged in the application database.
I haven't ever done it but I have heard there are transaction log parsers which can open and read the transaction log. If that is true then maybe you could load up that days transaction log and search for the value that was updated. Not sure if the default trace would still contain the information. Since you said auditing for that event was not on, your options are very slim.