rather than using a trigger to do this can you do the same by EXECuting a stored procedure (SP).

Within the SP you could also have the update within a TRANsaction...

easy to understand despite the english - not sure about the hard disk part at the start though