sql-serversql-server-2005sql-server-expressmdfldf

How to query from log files (.ldf) of Sql Server 2005 Express edition?


I want to do this, because I would like to know how many times a particular row has been changed.

Is this possible?

Thanks


Solution

  • Reading the log file either takes a commercial tool, or an incredible amount of SQL internals knowledge to achieve. You can see some of the raw output by using: Select * from ::fn_DBlog(null,null)

    Actually decoding to find the same record being altered and ensuring any alteration was committed etc would be a difficult task to put it lightly. So it is 'possible' but not very 'probable' that you will be able to do it.

    If you need that functionality within a database then you should be looking at triggers / logic within the code.