tracking of changes inside a database

Question

tracking of changes inside a database

ramyours2003

SSChampion

Points: 12268
More actions
June 29, 2010 at 1:14 am

#140886

i HAVE A DOUBT , IS SQL SERVER IS DESIGNED TO TRACK THE CHANGES OF A DATABSE , IF YES HOW CAN WE TRACK THE CHANGES INSIDE A DATABASE AT A POINT OF TIME .

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

Hi

What are the changes that you want to track? You can use DDL triggers or read from the default trace. It depends on what you are trying to do.

"Keep Trying"

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Please don't post in all caps, it's the online equivalent of shouting at us.

To track changes you need either triggers (DDL for structure changes, DML for data changes) or a server-side trace. Which you use depends on exactly what you want. Can you clarify requirements?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ramyours2003 SSChampion Points: 12268 More actions · Answer 3

thanks for your responses , we want to track all the datachanges which updated in the database recently . is SQL server is supported

inlogging of records all the datachanges of aparticular database .

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

You need triggers on the tables that you want to track.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 5

Although if you move to SQL Server 2008 (or R2), you can use Change Data Capture to perform this type of change tracking without using triggers.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Grant Fritchey (6/29/2010)
Although if you move to SQL Server 2008 (or R2), you can use Change Data Capture to perform this type of change tracking without using triggers.

Or Change Tracking, depending on the edition.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass