USE [AdventureWorks];
GO
CREATE TABLE TestTrigger (ID INT)
GO
CREATE TABLE TestTriggerAudit (ID INT)
GO
CREATE TRIGGER trTestTrigger ON TestTrigger
FOR INSERT
AS
INSERT INTO TestTriggerAudit SELECT * FROM inserted;
GO
INSERT INTO TestTrigger VALUES (1);
GO
CHECKPOINT;
INSERT INTO TestTrigger VALUES (22);
DBCC LOG('AdventureWorks', 3);
DROP TABLE TestTrigger;
DROP TABLE TestTriggerAudit;