Listing 1: Creating a Copy of a Table and Two Triggers on It

-- Turn off the snapshot options
ALTER DATABASE AdventureWorks
  SET ALLOW_SNAPSHOT_ISOLATION OFF
ALTER DATABASE AdventureWorks
  SET READ_COMMITTED_SNAPSHOT OFF
GO
-- Make a copy of the Department table (15 rows)
USE AdventureWorks
SELECT *
INTO Department
FROM  HumanResources.Department
GO
-- Create two triggers, one for UPDATE and
-- one for DELETE
CREATE TRIGGER upd_Department
ON Department
FOR UPDATE
AS
SELECT count(*) AS NumRows, 
    (sum(record_length_first_part_in_bytes)  + 
     sum(record_length_second_part_in_bytes))/8060.
       AS Version_store_Pages 
FROM  sys.dm_tran_version_store
GO
CREATE TRIGGER del_Department
ON Department
FOR DELETE
AS
SELECT count(*) AS NumRows, 
    (sum(record_length_first_part_in_bytes)  + 
     sum(record_length_second_part_in_bytes))/8060.
       AS Version_store_Pages 
FROM  sys.dm_tran_version_store
GO




1