C2 Audit and BCP

From: James Talbut (Please.Respond.Via_at_Newsgroups.com)
Date: 05/26/04


Date: Wed, 26 May 2004 07:04:27 +0100

I have a system that requires the functionality of c2 audit mode.
Unfortunately most the manipulations that will be taking place on this
system will be using BCP (actually they'll be using IRowsetFastLoad, but the
effect is the same).
If I use Profiler to record SQL statements each of the BCP transactions
comes out as insert bulk SQL statement.
But the audit event just contains garbage (little squares, non-printable
characters) and does not enable me to determine anything useful at all.

Has anyone else encountered this?
Has anyone been able to log BCP statements using c2 audit on SQL Server 2000
SP3a?
Does anyone know if a bug already exists for this?

Thanks.

J.T.