Hi Nicholas,
If you mean changes in table's structure, then you need database trigger.
If you mean data changes in table, then
- Auditing table in MS SQL Server x.y Enterprise (I did test with MS SQL 2008R enterprise).
- Or own solution - trigger on table.
MartinaJ
>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