also can do for INSERT CREATE TRIGGER trig_vacReq ON  dbo._vac FOR DELETE AS BEGIN INSERT INTO dbo._vacLog (vacRequestID, firstname, lastname, startdate, enddate, date_entered, LogDate, logevent) SELECT vacRequestID, firstname, lastname, startdate, enddate, date_entered, GETDATE() as LogDate, ‘Deleted’ as LogEvent FROM Deleted END