Web Listing 3: trgLogBug

CREATE TRIGGER trgLogBug 
ON tabConfigSettings 
FOR insert 
AS

INSERT tabBugReports (TestID, ConfigItem, DateLogged, 
  ExpectedSetting, ActualSetting,Tester, Status)
SELECT SettingID, ConfigItem, getdate(),
  ExpectedSetting, ActualSetting, Tester, 'Debugging'
FROM inserted
WHERE testresult = 'FAIL'
GO