article Properties, Commands Tab
The following options are available on the Commands tab of the article Properties dialog box. This tab is not displayed for snapshot or merge publications, or for transactional publications that allow immediate updating or queued updating subscriptions or transactional publications that allow transformations of published data.
Options
Replace INSERT commands with this stored procedure call
Use a custom stored procedure at each Subscriber in place of the INSERT command published by the Publisher. You can use the stored procedure named and created automatically, or you can use your own specified custom stored procedure. If you specify that all Subscribers are running SQL Server, this option is automatically selected. If you include heterogeneous Subscribers, you must clear this option for the heterogeneous Subscriber to receive the INSERT commands.
Replace UPDATE commands with this stored procedure call
Use a custom stored procedure at each Subscriber in place of the UPDATE command published by the Publisher. You can use the stored procedure named and created automatically, or you can use your own specified custom stored procedure. The custom stored procedure must be specified with an M call. If you specify that all Subscribers are running SQL Server, this option is automatically selected. If you include heterogeneous Subscribers, you must clear this option for the heterogeneous Subscriber to receive the UPDATE commands.
Replace DELETE commands with this stored procedure call
Use a custom stored procedure at each Subscriber in place of the DELETE command published by the Publisher. You can use the stored procedure named and created automatically, or you can use your own specified custom stored procedure. If you specify that all Subscribers are running SQL Server, this option is automatically selected. If you include heterogeneous Subscribers, you must clear this option for the heterogeneous Subscriber to receive the DELETE commands.
Create the stored procedures specified above during initial synchronization of the Subscribers
Create the stored procedures automatically at the Subscriber because they do not exist there. If you have created your own custom stored procedures at the Subscriber, clear this option.
Send parameters in binary format
Send the stored procedures in the most efficient format.
Use column names in commands that are not replaced by stored procedures
Use the table column names in all SQL statements.