Change Auditor Data level Auditing stops working

Hello,

I have Data level auditing turned on, initially it did record record level changes.. however, suddenly it stopped. I looked on the Knowledge Base and ensured that all the articles related were either verified or addressed. not sure what left to do.

Any thoughts?

 

  • Figured out the issue, weird, first I rebooted the server and restarted agents.
    Initially, when creating Data Level Auditing Template, I specified tables and columns. but the filter was "Like" not "=". however, after I changed it to "=" as I actually picked the tables and columns within the wizard. but the change did not work. so, I had to change it back to "Like" for it to work. Bug maybe?? not sure. but it works for me now. so I'm happy. thought I would share.