http://www.codeproject.com/Articles/338183/SQL-Server-Change-Tracking-on-Table-Without-Trigge

MartinaJ

>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