I’ve written about the SQL Transaction log before and since some of my clients don’t have some of the great logging tools, I often find myself going back to the
select * from ::fn_dblog(NULL,NULL)
Recently, at one client, I’ve come across a bizarre problem that defies easy analysis.
The VFP application uses cursor adapters to talk to the SQL Server and in one of the processes, updates one table while adding a record to two other tables. In certain circumstances, the two new records were being added but the update of the other table would not.
While I’m still tracking down what is actively going on, I wanted to note some of the interesting aspects of the SQL Log and pose some questions
A great post in SQLServerCentral broke down the various operation types but it wasn’t clear on others: