CREATE DATABASE TriggerTest

GO

USE TriggerTest

GO

CREATE TABLE T
  (
     X INT PRIMARY KEY,
     Y VARCHAR(100),
     Z VARCHAR(100)
  )

GO

CREATE TRIGGER T_TR
ON T
AFTER UPDATE
AS
    DONOTHING:

GO

INSERT INTO T
VALUES     (1,
            REPLICATE('A', 100),
            REPLICATE('B', 100)),
            (2,
             REPLICATE('C', 100),
             REPLICATE('D', 100))

BEGIN TRAN

UPDATE T
SET    Y = REPLICATE('E', 100)

GO

DBCC TRACEON (3604)

DECLARE @page_id INT
DECLARE @C1 AS CURSOR;

SET @C1 = CURSOR FAST_FORWARD
FOR SELECT page_id
    FROM   sys.dm_os_buffer_descriptors
    WHERE  database_id = 2
           AND is_modified = 1

OPEN @C1;

FETCH NEXT FROM @C1 INTO @page_id;

WHILE @@FETCH_STATUS = 0
  BEGIN
      EXEC('DBCC PAGE (tempdb, 1, ' + @page_id + ', 2) WITH NO_INFOMSGS ')

      FETCH NEXT FROM @C1 INTO @page_id;
  END

GO

ROLLBACK