Home Forums Article Discussions Article Discussions by Author Discuss content posted by Serge Mirault Capture CREATE, DROP, ALTER from the default SQL trace file RE: Capture CREATE, DROP, ALTER from the default SQL trace file

  • March 29, 2015 at 9:22 am

    #1787167

    MyDoggieJessie (3/26/2015)

    Interesting! I have no experienced this issue.

    It could be that you're filling up your files faster than the job is able to pull them out...so it's getting overwritten before the job picks back up again.

    You could try extending the number of files out, or shortening the timeframe the collection job is running

    I have 5 rolling files, but the code does only uses the current file. So I am going to have to write the file each time to a table, thus if they do not match I can read the old file first, and then the current file in use. That should fix the missing DDL statements.