Export (0) Print Expand All Expand Minimize This topic has not
yet been rated - Rate this topic  sp_publication_validation
(Transact-SQL)  Initiates an article validation request for each
article in the specified publication. This stored procedure is
executed at the Publisher on the publication database.  Topic
link icon Transact-SQL Syntax Conventions
sp_publication_validation [ @publication = ] 'publication'     [
, [ @rowcount_only = ] type_of_check_requested ]     [ , [
@full_or_fast = ] full_or_fast ]     [ , [ @shutdown_agent = ]
shutdown_agent ]     [ , [ @publisher = ] 'publisher' ]
[@publication =] 'publication'   [@rowcount_only =]
rowcount_only  Is whether to return only the rowcount for the
table. rowcount_only is smallint and can be one of the following
values.  Value Description   Perform a SQL Server 7.0 compatible
checksum.  When an article is horizontally filtered, a rowcount
operation is performed instead of a checksum operation.  1
(default)  Perform a rowcount check only.   Perform a rowc