Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

Performs a publication-wide validation for which all subscriptions (push, pull, and anonymous) will be validated once. This stored procedure is executed at the Publisher on the publication database.


sp_validatemergepublication [@publication =] 'publication'
    , [ @level = ] level


[@publication =] 'publication'

Is the name of the publication. publication is sysname, with no default.

[@level = ] level

Is the type of validation to perform. level is tinyint, with no default. Level can be one of these values:

Level value Description
1 Rowcount-only validation.
2 Rowcount and checksum validation.
3 Rowcount and binary checksum validation.

A validation level of 3 is valid only when Subscribers are running Microsoft® SQL Server™ 2000.

Return Code Values

0 (success) or 1 (failure)


sp_validatemergepublication is used in merge replication.


Only members of the sysadmin fixed server role can execute sp_validatemergepublication.

See Also

System Stored Procedures

Validating Replicated Data

© 2015 Microsoft