Export (0) Print
Expand All
Expand Minimize

article Properties, Commands Tab

SQL Server 2000

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.

See Also

Transactional Replication

Using Custom Stored Procedures in Articles

Show:
© 2014 Microsoft