We have about 50 customers in hosted environment, each running databases
withi identical schema but different names. Part of the application traps
errors and records them in a log table. I want to consolidate these logs
into a single database so we can easily view errors without having to look
at each customers log individually. Perhaps there is a better way, but I
want to put a trigger on each customer's log table that inserts a copy of
new entries into the central error database. This entry in the central
database needs to include the name of the originating database, ...