sp_validatemergesubscription (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_validatemergesubscription (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Performs a validation for the specified subscription. This stored procedure is executed at the Publisher on the publication database.

Topic link icon Transact-SQL Syntax Conventions

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



Rowcount-only validation.


Rowcount and checksum validation.


Rowcount and binary checksum validation.

0 (success) or 1 (failure)

sp_validatemergesubscription is used in merge replication.

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

Community Additions

© 2016 Microsoft