Although this thread is ancient history, a couple more points -

Microsoft's implementation of triggers disallows the modification of data being persisted. So if you wanted a field named date_last_modified on...