• 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