Reporting on audit trails (SE)

I need to access the data written to an audit trail from SE. Using SQL is preferred, but I can't find the notes I once had on exactly how to do it. It was easy enough to figure out that I need to create a table containing something like... audit_flag char(2) audit_time integer audit_pid smallint audit_uid smallint audit_rowid integer followed by the same columns as in the table being audited. Then I can copy the audit file over the top of this table's .dat file. Now I can select from the audit table, BUT I only get one row. Bcheck the dat/idx, and still I only get one row. What am I missing? -- Hugh Grierson hugh@fujitsu.co.nz 16C, clear, cool southerlies