How to store the autoaudit details in a database other than the database on which the autoaudit is created.

Jul 15, 2014 at 7:12 AM
I am trying to store the audit objects in another database and trying to create the audit in another database where the tables for audit will be stored.

How can it be achieved.
Coordinator
Jul 15, 2014 at 2:10 PM
This is not supported by AutoAudit. The audit tables have to be in the same database as where the base table exists.
Aug 11, 2014 at 3:17 PM
I have built a Version, which can be used for multi-database Environment: Audit Tables are in _log DBs and _Archiv DBs. I just found out, that we cannot use it as is for a SQL Server 2000 Version, because of the UNPIVOT Statement.
Does anybody has a solution for that?