We have an old 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
July 14, 2008 11:01 PM
July 15, 2008 12:05 PM