Listing C: Script to Create Triggers on the Customers Table

CREATE TRIGGER trg_Customers_INSERT ON dbo.Customers AFTER INSERT
AS
PRINT 'INSERT detected.';
GO
CREATE TRIGGER trg_Customers_UPDATE ON dbo.Customers AFTER UPDATE
AS
PRINT 'UPDATE detected.';
GO
CREATE TRIGGER trg_Customers_DELETE ON dbo.Customers AFTER DELETE
AS
PRINT 'DELETE detected.';
GO