Information générale
Forum:
Microsoft SQL Server
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement