Solved

Sql Updates

Posted on 2009-05-04
3
188 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:lothos123452000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 250 total points
ID: 24295072
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.
0
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 250 total points
ID: 24295096
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.
0
 

Author Closing Comment

by:lothos123452000
ID: 31577533
Thanks for the help. You pointed me in the right direction.
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question