If you already have defaults, there is no need for triggers. You can use the
DEFAULT keyword in your INSERT & UPDATE DMLs like:

INSERT tbl (..., Modby, ModDate) VALUES (..., DEFAULT, DEFAULT);

UPDATE tbl
SET ....
ModBy = DEFAULT,
ModDate = DEFAULT
WHERE ...;

--
-- Anith
( Please reply to newsgroups only )