Sql Updates

I have a table that was updated. I need to find out what field in that table was updated? Is there somekind of logfile or table that sql keeps that records changes performed on a table. If so I would I get access to that? Any help given is greatly appreciated.
Who is Participating?
chapmandewConnect With a Mentor Commented:
No, not really.  You could potentially use a 3rd party log reader (if you're doing log backups), but other than that, SQL doesn't provide a way to do this.
RiteshShahConnect With a Mentor Commented:
there is no direct way to do so you have to go for third party log reader software may be red-gate tool kit. As long as future concern, you can have audit trail trigger. It will help log every update for you but that is for future, can't get anything directly right now.
lothos123452000Author Commented:
Thanks for the help. You pointed me in the right direction.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.