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;

We walk in the dark places no others will enter
We stand on the bridge and no one may pass