?
Solved

Transaction update records

Posted on 2010-01-08
1
Medium Priority
?
195 Views
Last Modified: 2012-05-08
I need a refresher on SQL transactions.  How and where are table record updates recorded in SQL 2008 or 2005?  I need to get a list of all changes made to a table from a starting date to a final date.  Is it possible to get notifications of individual field changes made in a table?  If so, please give me an insight on how to...  

TIA


Dennis Kean
 
0
Comment
Question by:datalite
1 Comment
 
LVL 21

Accepted Solution

by:
JestersGrind earned 2000 total points
ID: 26210524
SQL Server doesn't do any kind of auditing by default.  In SQL Server 2005, you would have to have triggers in place to capture the data that you're looking for.  In SQL Server 2008, it's a little easier with a new feature called Change Data Capture (CDC).  You can enable it on the database and then the individual table to capture auditing information.  Also this feature is only available in Enterprise, Developer and Evaluation editions.

Greg


0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Integration Management Part 2
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

839 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