We are planning on using the new auditing feature in SQL Server 2008. Is there a way to configure the auditing component to insert audit data to a separate database?
I don't believe so. It's to-file (rolling log) or to event viewer. This is a good reference: http://www.sqldbatips.com/showarticle.asp?ID=133