Question: In the past I have just added an field to each table and updated it with GETDATE() on every update/insert. The problem is now I have to keep track of delete too. I was thinking of just having a table that I would update when anything changed and add a trigger to all of the other tables. Ideas??? Thanks!

Answer: 
If you are using SQL Server 2008, you can take advantage of the [new auditing features](http://msdn.microsoft.com/en-us/library/cc280386.aspx).
If you are using SQL 2008 then you can use CDC(Change Data Capture) for the tracking. 

The below link gives the full details. If you are enabling the cdc for particular table then automatically delete data's will be collected. 

<http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/>