The method you're describing would probably work the easiest. The only other way to do it would be to write a custom rule for the Responder server and have it do the processing, but that would involve actually coding and installation.
The only thing you would have to watch out for are the upgrade scripts that can modify database schema. They might modify/delete your trigger and you would have to re-implement it. Not hard, but something to be aware of.