We have an server that runs SQL Server 7 on an NT system. One database has
processes running that are not documented. I have written triggers to report
any deletions, inserts or updates made against the database's tables. All I
can report is that an insert, update or delete has occurred, the Date and
Time it occurred, and the table the operation was against.

I have read that temporary/virtual tables are created whenever an insert,
update or delete occurs. I have not found any documentation about these
temporary/virtual tables.

I have not been able to get the logs running. Viewing the logged data should
give me an idea of what actions are taking place. The way that I enabled the
Log Security Events was by Right-Clicking on the registered server and
choosing properties, then clicking on the security tab, and enable 'All'
audit level. To view the logs, in SQL Enterprise Manager-->Management-->SQL
Server logs. I have 6 old logs that span a few hours for a given day. These
days are either late last year and very early this year.

Does anyone have information about the temporary tables or logging an SQL
Server 7? Any help would be appreciated. Thanks