There are a lot of factors need to be considered when one needs to audit all activites on tables.
There is something called C2 Autditing that MSSQL 2000 supports. You may want to read some articles on that.
C2 auditing records information that goes beyond server-level events, such as shutdown or restart, successful and failed login attempts, extending it to successful and failed use of permissions when accessing individual database objects and executing all Data Definition, Data Access Control, and Data Manipulation Language statements. The audit information contains the timestamp, identifier of the account that triggered the event, target server name, event type, its outcome (success or failure), name of the user's application, and Server process id of the user's connection.
Check this link SQL Server 2000 Security - Part 10 - Auditing
Hope that helps.
- Vijay G
Strive for Perfection