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 validation for the specified subscription. This stored procedure is executed at the Publisher on the publication database.


sp_validatemergesubscription [@publication =] 'publication'
    , [ @subscriber = ] 'subscriber'
    , [ @subscriber_db = ] 'subscriber_db'
    , [ @level = ] level


[@publication =] 'publication'

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

[@subscriber =] 'subscriber'

Is the name of the Subscriber. subscriber is sysname, with no default.

[@subscriber_db =] 'subscriber_db'

Is the name of the subscription database. subscriber_db 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.

Return Code Values

0 (success) or 1 (failure)


sp_validatemergesubscription is used in merge replication.


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

See Also

System Stored Procedures

Validating Replicated Data

Validate Subscriber Information

© 2015 Microsoft