SQL Server 2008 has two facilities for monitoring changes to a table to facilitate (e.g.) loading of a data warehousing or building an online/offline application with syncronisation capabilities.
In this video we take a look at "Change Tracking" which provides notification of net changes made to data during a period of time and is a good basis for building of an application requiring one or two way synch.
Comments