Solved

Sql Updates

Posted on 2009-05-04
3
187 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need help creating a stored procedure 4 63
SQL Server Degrading on Write 13 70
Caste datetime 2 64
Present Absent from working date rage 11 36
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 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