TSQL: Trigger on a table to catch delete command Posted by herbee on Wednesday, 25.January.2012 CREATE TRIGGER [dbo].[nodelete] ON [dbo].[LBSysEvents] INSTEAD OF DELETE AS BEGIN IF 1=1 BEGIN RAISERROR(‘You cannot delete’,16,1) RETURN; END END