Change Tracking & Change Data Capture

Change Tracking is supported on our SQL Servers 2008. Before using it, you will need to enable change tracking first at database level, and then at the table level. You can use the following T-SQL code below or GUI in your Management Studio.

Code:

ALTER DATABASE [YourDatabaseName]
SET CHANGE_TRACKING = ON

Code:

ALTER TABLE [YourTableName]
ENABLE CHANGE_TRACKING

Change Data Capture is not supported in our shared hosting environment because of the storage and performance overhead involved.