Only thing I'd add is

REPLACE repmod with DATE() IN Dept

>I'm converting an app from VFP to SQL Server 2005 and I've just had a stab at converting my first trigger. Any comments on the code I used. The purpose of the trigger is to update a field with the current date, if 1 of 2 fields have changed.
>
>VFP Function called by the record validation event.
>
>

>FUNCTION dept_rv()
>	
>	SELECT dept
>	IF 	dept.repdate <> oldval("repdate","dept") OR ;
>		dept.repstaff <> oldval("repstaff","dept")
>		REPLACE dept.repmod WITH date()
>	ENDIF
>
>	RETURN .T.
>ENDFUNC
>

>SQL Server Update Trigger
>

>
>set ANSI_NULLS ON
>set QUOTED_IDENTIFIER ON
>go
>
>ALTER TRIGGER [Trigger_Dept_Update] on [dbo].[dept] AFTER UPDATE AS
>    IF UPDATE(repdate) or UPDATE(repstaff)
>		BEGIN
>			UPDATE Dept SET repmod = GETDATE() FROM Dept INNER JOIN inserted ON dept.id = inserted.id
>		END
>