Share via


How to: Define a Logical Record Relationship Between Merge Table Articles (SQL Server Management Studio)

Note

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Define logical records in the Add Join dialog box, which is available in the New Publication Wizard and the Publication Properties - <Publication> dialog box. For more information about using the wizard and accessing the dialog box, see How to: Create a Publication and Define Articles (SQL Server Management Studio) and How to: View and Modify Publication and Article Properties (SQL Server Management Studio).

Logical records can be defined in the Add Join dialog box only if they are applied to a join filter in a merge publication, and the publication follows the requirements for using precomputed partitions. To define logical records that are not applied to join filters and to set conflict detection and resolution at the logical record level, you must use stored procedures. For more information, see How to: Define a Logical Record Relationship Between Merge Table Articles (Replication Transact-SQL Programming).

Note

If you add, modify, or delete a logical record in the Publication Properties - <Publication> dialog box after subscriptions to the publication have been initialized, you must generate a new snapshot and reinitialize all subscriptions after making the change. For more information about requirements for property changes, see Changing Publication and Article Properties.

To define a logical record relationship

  1. On the Filter Table Rows page of the New Publication Wizard or the Filter Rows page of the Publication Properties - <Publication> dialog box, select a row filter in the Filtered Tables pane.

    A logical record relationship is associated with a join filter, which extends a row filter. Therefore you must define a row filter before you can extend the filter with a join and apply a logical record relationship. After one join filter is defined, you can extend this join filter with another join filter. For more information about defining join filters, see How to: Define and Modify a Join Filter Between Merge Articles (SQL Server Management Studio).

  2. Click Add, and then click Add Join to Extend the Selected Filter.

  3. Define a join filter in the Add Join dialog box, and then select the check box Logical Record.

  4. If you are in the Publication Properties - <Publication> dialog box, click OK to save and close the dialog box.

To delete a logical record relationship

  • Delete only the logical record relationship or delete the logical record relationship and the join filter associated with it.

    To delete only the logical record relationship:

    1. On the Filter Rows page of the New Publication Wizard or the Filter Rows page of the Publication Properties - <Publication> dialog box, select the join filter associated with the logical record relationship in the Filtered Tables pane, and then click Edit.

    2. In the Edit Join dialog box, clear the check box Logical Record.

    3. Click OK.

    To delete the logical record relationship and join filter associated with it:

    • On the Filter Rows page of the New Publication Wizard or Publication Properties - <Publication> dialog box, select a filter in the Filtered Tables pane, and then click Delete. If the join filter you delete is itself extended by other joins, those joins will also be deleted.