This topic has not yet been rated - Rate this topic

Table Properties (Change Tracking Page)

SQL Server 2008 R2

SQL Server 2008

Use this page to view or modify change tracking settings for the selected table. For more information about the options available on this page, see Configuring and Managing Change Tracking.

Options

Change Tracking

Indicates whether change tracking is enabled for the table. The default value is False.

This option is available only when change tracking is enabled for the database. For more information, see Database Properties (ChangeTracking Page).

To enable change tracking, the table must have a primary key, and you must have permission to modify the table.

You can also configure change tracking by using ALTER TABLE.

Track Columns Updated

Indicates whether the SQL Server Database Engine tracks which columns were updated.

Reference

ALTER TABLE (Transact-SQL)

Concepts

Configuring and Managing Change Tracking

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD