Hi Martina..

In this case its data changes


Which is the auditing table in SQL Server.


Thanks


Nick


>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