The log file increaseing in size merely implies the mdf file is being written to, it's not really conclusive evidence that it is being writtent to. Just because one grows...

Yeah sorry I appreciate its all done in memory but I was referring to the write back stage.

That's pretty much answered my question, cheers.

Okay so getting a little more specific. Does the SQL Server edit the MDF file and overwrite the current value of that record or does it carry out a check...

Ask a simple yes/no question and get a few tangent replies, damn.

Its quite simple. You have a table as follows.

CREATE TABLE Test (

ID INT IDENTITY(1,1)

...