How to set row- or column-level tracking for an article (Transact-SQL)

How to Install SQL Server 2000

How To

How to set row- or column-level tracking for an article (Transact-SQL)

  • If you are adding a merge article to a publication, set the @column_tracking parameter of the replication stored procedure sp_addmergearticle to true for column-level tracking or to false for row-level tracking.

  • If you are changing the properties of an existing inactive merge article in a publication, set the @property = parameter of the replication stored procedure sp_changemergearticle to column_tracking, and then set the @value = parameter to true for column-level tracking or to false for row-level tracking.

If this property is changed after the publication has active subscriptions, the current snapshot will become obsolete and existing subscriptions will be marked for reinitialization.