Can Python Parse an MS SQL Trace?

[kyosohma at gmail.com]

On May 7, 8:34 am, Tim Golden <m... at timgolden.me.uk> wrote:
> kyoso... at gmail.com wrote:
> > Can Python parse a trace file created with MS SQL's profiler? There
> > are a few thousand lines in the trace file and I need to find the
> > insert statements and the stored procedures. Unfortunately, I am not
> > an SQL guru and was hoping Python could help.
> > Mike
>
> Mike,
>
> Can I suggest that, since the answer is more to
> do with parsing and less to do with MSSQL (which
> simply generated the output) that you post an example
> of a trace file to some web location to see if anyone
> wants to pick up the challenge?
>
> I'm not at work so I don't have access to MSSQL, but
> I seem to remember that you can output/save as XML,
> which may make things easier (or at least interest a
> different group of people in having a look).
>
> I'm quite certain it can by done by Python; I did
> consider it myself a couple of months back, but my
> colleague spotted the problem before I'd really got
> into the code!
>
> TJG

Good point. Unfortunately, I think our SQL Server must be too old for
xml (we have version 8). The only save options I see is Trace
Template, Trace File, Trace Table and SQL Script.

Mike