Inside Microsoft® SQL Server® 2008: T-SQL Programming

Chapter 15. Tracking Access and Changes to Data

Greg Low

Microsoft SQL Server 2008 introduced a number of new technologies related to tracking changes to data. Although alternatives have been available for this in earlier versions of the product, tracking access to data has been more difficult in the past. SQL Server 2008 helps address this need.

Which Technology Do I Use?

We need to track access and changes to data for several reasons:

• Auditing and compliance have become very important issues in recent years. We need to be able to answer questions on who accessed which data and when they did it.

• We need to be able to support occasionally connected systems and mobile workforces.

• We need to be able to incrementally load data warehouse systems.

We can ...