>create trigger <trigger name> ON <table> >for update >as >begin > -- exit trigger if update is on LastUpdate field > if update(LastUpdate) > return > > -- get key field to use for filter > declare @lckey char(20) > select @lckey = <key field> from inserted > update custFL set LastUpdate = GetDate() where <key field> = @lckey >end >