I'm working on an application, which uses different DLLs, each of them doing something on an MS-SQL database. After a while, some entries in the database don't look as I would want them, and I would like to monitor all the modifications, which have led to this situation, something like:
at 12:00:01.234 : modify "Status" from 2 to 3 at 12:00:02.345 : modify "Destination" from "ABC01" to "ABC02". at 12:00:02.456 : modity "Status" from 3 to 4
Because currently, I see that "Status" is 4 and that "Destination" is "ABC02", but I have no idea about when and how this has happened. (My question is similar to asking to read the archive logs of an MS-SQL database, if this makes any sense :-) )
Thanks in advance
Edit: some clarification:
On the internet, there are quite some explanations on database monitoring, but in almost all cases, the idea is to measure and to improve the performance. For my question, this is not the case: I just want to understand, piece by piece, how the data in one particular table go from one value to the other one.
In the meantime, I've started using
fn_dblog, as follows:
SELECT * FROM fn_dblog(null,null) WHERE UPPER(AllocUnitName) LIKE '%TABLENAME_STATUS%'
... but I have no idea how to see the timestamp. Does anybody have an idea?
Edit2 about fn_dblog:
As far as specific
fn_dblog information is concerned, I've created a new question for this subject.