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).
Flag the records as deleted=1 and do not delete it. Do a trigger on delete instead update...