Web Listing 6: Checking the Amount of Logging Using a Temporary Table
CHECKPOINT;
BEGIN TRAN
SELECT COUNT(*) FROM fn_dblog(NULL, NULL);
SELECT n
INTO #T
FROM fn_nums(1000000);
SELECT COUNT(*) FROM fn_dblog(NULL, NULL);
COMMIT TRAN