May 27, 2010 at 5:51 pm
Hello All,
I have learnt the SQL 2008 has simplified audit version, which enables us to audit the objects, schema, database, server and so on.
Now I would like to explore more on data auditing rather than object. I would like to know is there any way to know whether particular empid(for e.g.) was accessed, modified or deleted. I understand that this can be achieved through triggers in sql server. But I want to know is there any simple solution(customized or inbuilt) in SQL server 2008 to track what happens to particular records?
Please let us know your thoughts on this.
Thanks
Bala
June 2, 2010 at 6:16 pm
No one has replied to my question. However I found that the CDC(change data capture) feature can be implemented to track changes happening to the data. This is the alternative to triggers which is used track changes in previous version of SQL server
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply