We are looking at instituting a SOX-like log table that will grow
considerably over time. Typical log inserts would be recording:

* creation of an inventory/inventory item
* creation of an order
* creation of an advertising campaign
* changes made to any of the above

We prefer the idea of a separate database than adding a table to the
already big (2-8 GB) databases at our customer sites.

* What are the advantages of using a second database?
* What are the advantages of adding a table to an existing database?
* What suggestions do you have based on your experience?

Thanks!

-Eduardo