Validates a subscription.
sp_validatesub sub_name [, rep_art]
is the name of the subscription that contains replicate articles to validate.
is the name of a replicate article to validate.
sp_validatesub subdoc, repdoc
Validates the replicate article repdoc in the subscription subdoc.
Before you invoke sp_validatesub, you must suspend the subscription using sp_suspendsub. After the replicate article is validated, you can resume the subscription using sp_resumesub.
When a replicate article is validated, the Publisher component places a marker in the stable queue indicating the point at which transaction distribution for that replicate article should begin. Any transactions to which the replicate article subscribes that occur prior to the marker in the stable queue are not distributed to the replicate object identified in the replicate article.
To be ready for replication, replicate articles for tables must be materialized using sp_materializesub, unless the table already contains data synchronized with the primary database. If you choose not to use sp_materializesub to materialize the data in the replicate table, you must copy the appropriate data from the primary table to the replicate table to prepare for replication.
If you invoke sp_validatesub to validate a replicate article for a table, the subscription for that article is validated only, and not materialized.
To be ready for replication, replicate articles for stored procedures need only be validated using sp_validatesub.
When you invoke sp_validatesub and specify only a subscription (sub_name), all replicate articles in the specified subscription are validated.
When you invoke sp_validatesub and specify a subscription (sub_name) and a replicate article (rep_art), the specified replicate article in the specified subscription is validated.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.