Re: C2 Audit and BCP

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

Date: Thu, 27 May 2004 06:12:51 +0100

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.
>
>
>

Relevant Pages

  • Re: Bulkinsert Problem
    ... An alternative approach may me to use the SQL Server Bulk Copy Command ... For more details refer to the "bcp Utility" article in SQL ...
    (microsoft.public.sqlserver.programming)
  • RE: Bulk Copy / BCP problem....please advise
    ... >slower than using bcp or bulk insert but it could help. ... >> regular basis into my SQL Server using either Bulk ...
    (microsoft.public.sqlserver.programming)
  • Re: Bulk Insert With Identity Field
    ... > You can use a format file ... > columns and bcp into that. ... >>Can I Bulk Insert to to SQL Table with a Identity Column ...
    (microsoft.public.sqlserver.programming)
  • Re: Import User Records
    ... Do I need to export records first from SQL 6.5? ... > You can, fro SQL2K, use DTS. ... Other options include BCP, BULK INSERT. ...
    (microsoft.public.sqlserver.server)
  • Re: Identity Block Reserved For Inserts Issue - Are you good?
    ... I have a bit of a complicated question, hope we have an SQL guru out there ... Because we need to get all the linking before we BCP, ... used or were used by a competing process that uses only automated identity ... Use lock hints to lock out the competing processes until you're ...
    (microsoft.public.dotnet.languages.csharp)