Export (0) Print
Expand All
Expand Minimize

Stored Procedure Article Properties, Other Tab

SQL Server 2000

The following options are available on the Other tab of the Stored Procedure Article Properties dialog box.

Options

Keep the existing stored procedure

If the stored procedure already exists at the Subscriber, keep the existing stored procedure at the Subscriber but do not publish this stored procedure.

Drop the existing stored procedure

If the stored procedure already exists at the Subscriber, drop the stored procedure at the Subscriber and publish this stored procedure.

For stored procedure articles in transactional publications that do not allow updatable subscriptions, you can publish the execution of the stored procedure in addition to the schema of the stored procedure. For more information, see Publishing Stored Procedure Execution.

Never replicate the schema only

Does not replicate the execution of the stored procedure.

Every time it is executed

Always replicate the execution of the stored procedure.

Only when it is executed inside a serializable transaction

Replicate the stored procedure when it is executed inside a serializable transaction.

Extended properties

Publishes all extended properties that exist with this stored procedure article.

See Also

Publishing Data and Database Objects

Show:
© 2015 Microsoft