Try this:
CREATE TRIGGER trg_UpdateDateModified
ON Employees
FOR UPDATE
AS
UPDATE Employees
SET DateModified = getdate()
FROM Employees
INNER JOIN inserted
on Employees.ID = inserted.ID;
I'm assuming the existence of an ID column in the Employees table. You'll need to modify it to use the correct primary key in the join if ID isn't what you're using.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon