Thank you! These sound both like very good ideas and certainly less problematic if something goes wrong. I have no experience with Event Notification and use of Service Broker and this is a nice opportunity to gain experience.
Implementing a server side trace would be fairly easy, but is there a way to get the results directly into a table other than regurlarly importing the results from out of the results file on the file system?