Solved

Sql Updates

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Modifying SQL 2008/2012 PARTITIONS 3 55
sql help 5 52
SQL Agent Timeout 5 47
SQL Server 2012 express 24 36
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
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.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now