Lokesh Vij (1/27/2013)
If you are looking to audit CURD operations on tables. Like if you want to know which columns have been updated and want to know the old values as well, an easy way is to implement Change Data Capture. Here is the link http://msdn.microsoft.com/en-in/library/bb522489(v=sql.105).aspxIn case you have a different requirement. Please do specify.
CDC is more like versioning than audit ; what does it mean by audit trail on daioy transactions ?
does it more related to logging of transaction by a login or logging of data ?
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: