?
Solved

Sql Updates

Posted on 2009-05-04
3
Medium Priority
?
191 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 1000 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 1000 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

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…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

762 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