Interview Questions, Sql Server Tutorials

#Sql Server interview question: What is change tracking inside SQL Server 2008?

Change Tracking was a much anticipated feature in SQL Server 2008. Prior to SQL Server 2008, SQL DBAs had to code complex triggers and archive tables in order to track changes made to their database tables.

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with some information about those changes. With change tracking integrated into SQL Server, complicated custom change tracking solutions no longer have to be developed.

Thanks for reading this article,

Next steps :

  1. Share this with your colleagues because Sharing  is Learning
  2. Comment below if you need any assistance

Powered by CodeReview – Let’s make it Better!