Specifying Columns During Replication

In SQL Server 6.5, the replication INSERT statements can include a column list. This column list guarantees that inserted data will populate the correct columns in the subscriber's table.

In SQL Server 6.0, INSERT statements that were generated by replication did not include a column list. This could result in replication errors if the subscribing table had columns in a different order than the source table, or if the subscribing table included columns that were not present in the source table.

Important This functionality should be enabled only if you suspect problems will occur with replication. Enabling the column list increases the length of the generated INSERT statements, resulting in higher storage requirements for the distribution database and increased network traffic.

    To create column lists for an article

1. Create a publication and articles.
2. From the Edit Publication dialog box, choose edit.

   The Manage Article dialog box appears.

3. Select the Use Column Names in SQL Statements check box.
4. Choose OK.