O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required