948
Part VII: Monitoring and Auditing
Enabling Tables
The ease to confi gure Change Tracking continues with enabling Change Tracking of each
table. Using Management Studio, table Change Tracking is viewed or enabled/disabled in
the Table Properties dialog, on the Change Tracking page, as shown in Figure 41-2.FIGURE 41-2
Use the Table Properties dialog to view the table’s Change Tracking settings.Like the database, Change Tracking is enabled using T-SQL for tables with an alter
command:ALTER TABLE HumanResources.Department
Enable Change_tracking
With (track_columns_updated = on);The only option is to enable or disable whether Change Tracking tracks which columns were
changed. By default, column tracking is disabled.c41.indd 948c41.indd 948 7/31/2012 10:17:20 AM7/31/2012 10:17:20 AM
http://www.it-ebooks.info