maybe soemthing like this might help?
you just need to test for the existence of any data int he INSERTED or DELETED virtual tables
CREATE TRIGGER TR_WHATEVER_NOTIFICATIONS
ON WHATEVER FOR INSERT,UPDATE,DELETE
AS
BEGIN
SET NOCOUNT ON
declare @optype tinyint = 0;
if exists (select * from INSERTED) set @optype = @optype + 1
if exists (select * from DELETED) set @optype = @optype + 2
--use soemthing like this?
/*
case @optype
when 1 then 'New row inserted into ConfigSet table in XXXXXX'
when 2 then 'Row deleted from ConfigSet table in XXXXXX'
when 3 then 'Row modified in ConfigSet table in XXXXXX'
else 'This should never happen'
end ;
*/
END --TRIGGER
GO
Lowell