Guru's Guide to SQL Server Architecture and Internals, The

Update Stored Procedures

The format of the actual commands the Log Reader Agent places in MSrepl_ commands varies based on how a particular article is set up. You can customize the way that DML commands are passed to subscribers for each table article in a publication. To do this, click the ellipsis button next to the table article in the Articles tab of the Publication Properties dialog. Select the Commands tab in the Table Article Properties dialog to configure the format of the commands sent to the subscriber. You have four options.

1. You can clear the Replace… checkboxes in order to cause the Log Reader to write plain INSERT, UPDATE, or DELETE statements to MSrepl_commands. If you are publishing for SQL Server subscribers only, it's better ...