Post reply

Auditing DDL and not DML from Sql Server 2000

  • October 19, 2006 at 1:14 am

    #60882

    I want to audit only ddl and not dml from sql server 2000.For this i use the C2 Audit trace file. But this file contains both DDL,DML information. Its size is an issue. Is there any other way to audit only ddl from sql server 2000.

    I also want to know that is there any way to store the audittrace file information into a table instead of creating the audtitrace file

    My requriement is to audit only DDL information (Create,Alter,Drop and not INSERT,SELECT,Exec procedureName)

    Thanks in Advance

    Regards

    parveen sharma

  • October 19, 2006 at 8:34 am

    #666816

    Audit for event number 118.  See 'sp_trace_setevent' in BooksOnLine. 

    Greg

    Greg

  • October 19, 2006 at 8:42 am

    #666818

    Also, though you can't write a trace directly to a table when using the stored procedures to create a trace, you can programatically copy the trace file to a table.  See this KB article: http://support.microsoft.com/kb/270599/en-us

    Greg

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply