Initiates a data validation request for the specified article. This stored procedure is executed at the Publisher on the publication database and at the Subscriber on the subscription database.
sp_article_validation [ @publication = ] 'publication' [ , [ @article = ] 'article' ] [ , [ @rowcount_only = ] type_of_check_requested ] [ , [ @full_or_fast = ] full_or_fast ] [ , [ @shutdown_agent = ] shutdown_agent ] [ , [ @subscription_level = ] subscription_level ] [ , [ @reserved = ] reserved ] [ , [ @publisher = ] 'publisher' ]
sp_article_validation is used in transactional replication.
sp_article_validation causes validation information to be gathered on the specified article and posts a validation request to the transaction log. When the Distribution Agent receives this request, the Distribution Agent compares the validation information in the request to the Subscriber table. The results of the validation are displayed in the Replication Monitor and in SQL Server Agent alerts.