There is a SQL setting [IIRC] which allows/disallows triggers firing triggers, if you are getting the recursive trigger error, then you have this setting enabled and an update in one trigger can ...