Audting Only DDL in Sql Server 2000

  • I want to audit only ddl from sql server 2000.For this i use the C2 Audit trace file. But this file grows and its size is an issue. Is there any other way to audit only ddl from sql server 2000.

    My requriement is that i dont want the extra space taken by file as generated by c2 audittrace---.trc file.

    Thanks in Advance

    Regards

    parveen sharmaw

  • I would suggest using a tool like Lumigent Log Explorer or another third party tool to do this.

    If you have budgetary constraints, then you can set up a trace with filters on the TextData to be like ALTER, CREATE etc.. and write this directly to a table in SQL Server.

    You might want to include system procedures like sp_rename etc.. also, and have a purge routine that cleans out data from the trace table on a periodic basis.

     


    I feel the need - the need for speed

    CK Bhatia

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

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