If you are using the BDC in your MOSS application, you may have noticed that the AUDEvent table in the SSP database can grow quite large and quickly. You might think that the stsadm command –o trimauditlog would do the trick in reducing this table, but in fact it does not work for the SSP database only content databases.
You can specify the audit setting in the Application Definition File. Simply add the Property ‘Audit’ to your Entity’s Properties section:
<Entities>
<Entity EstimatedInstanceCount="0" Name="dbo.Sales">
<Properties>
<Property Name="Audit" Type="System.Boolean">false</Property>
</Properties>
…
The setting of false will prevent any audit entries being written to the AUDEvent table.