>Hi
>
>I had some SQL (which I can't find. My bad) that detected changes in tables in a database.
>
>I used this to explore a database by putting in transactions through a front end and then seeing what had changed in the data so I could document an undocumented system
>
>
>Any ideas on SQL that would do that ?
>
>I had a quick google and couldn't find it.
>
>
>Thanks
>
>
>
>Nick
There are two ways without a trigger: Change Data Capture and SQL Server Audit.
For Change Data Capture you can check this very good article
http://blogs.lessthandot.com/index.php/datamgmt/datadesign/change-data-capture-sql-server-08/
If it's not broken, fix it until it is.
My Blog