--IF you want to accomodate updates then
CREATE TRIGGER trg_myTable_ModDate
  ON myTable
 AFTER INSERT, UPDATE
AS

UPDATE myTable set ModDate = GETDATE()
FROM myTable
JOIN inserted i
ON i.ID = myTable.ID -- where ID is your primary key



David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com