CHECKPOINT -- just to be sure and to allow for multiple tests
DECLARE @I int
SET @I = 10
WHILE @I > 0
BEGIN
BEGIN TRANSACTION
UPDATE test SET name = name
SELECT [Current LSN] ,
Operation ,
Context ,
[Transaction ID] ,
AllocUnitId ,
AllocUnitName ,
[Checkpoint Begin] ,
[Num Transactions] ,
[Checkpoint End] ,
[Dirty Pages] ,
[Log Record] FROM fn_dblog(NULL, null)
COMMIT
SET @I = @I - 1
END
Now - run it and watch the number of records in fn_dblog growing by 2 after each cycle.
_____________
Code for TallyGenerator