C2 Audit and BCP

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.BCP will use Native mode by default unless you specify character mode.
What exactly are you wanting to see?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I'd like to be able to identify that an "insert bulk" statement has
occurred.
All of the SQL Statements that are run are identified solely by the
permission event, we have to look at the text data column in Profiler to
establish what the SQL was - but when we use BCP we get a few permission
events but nothing legible in the text data column.
This isn't an issue with the functionality of BCP, it's an issue with the
audit events that profiler picks up.
What I'd like is to find the same text captured in the permissions event
(which is part of the audit set of events) as it captured by the SQL
statements events (which logs the "insert bulk" statement and identifies the
table and columns).
Thanks.
J.T.
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:cLXa5U3QEHA.3960@.cpmsftngxa10.phx.gbl...
> BCP will use Native mode by default unless you specify character mode.
> What exactly are you wanting to see?
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>