I am trying to create a trigger below:

CREATE TRIGGER TEMPLATE_AUDIT_TRIGGER
ON DBO_TEMPLATE
FOR UPDATE, INSERT, DELETE
AS
IF @@ROWCOUNT = 0 RETURN
IF UPDATE (ENDDATE)
BEGIN
INSERT DBO.TEMPLATE_AUDIT ( TEMPLATE_ID, LASTUPDATEUSER, LASTUPDATEDATE)
SELECT TEMPLATEID,
CURRENT_USER,
GETDATE() FROM
DBO_TEMPLATE
END
RETURN

The Update works, but I can not get the Insert or Delete to work when using
it like
IF INSERT (ENDDATE)
BEGIN
INSERT DBO.TEMPLATE_AUDIT ( TEMPLATE_ID, LASTUPDATEUSER, LASTUPDATEDATE)
SELECT TEMPLATEID,
CURRENT_USER,
GETDATE() FROM
DBO_TEMPLATE
END

How do I get the Insert and Delete to work in the above trigger?









Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed]MS Sql Server LazyDBA home page