Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Performs a publication-wide validation for which all subscriptions (push, pull, and anonymous) are validated once. This stored procedure is executed at the Publisher on the publication database.
Transact-SQL syntax conventions
sp_validatemergepublication
[ @publication = ] N'publication'
, [ @level = ] level
[ ; ]
The name of the publication. @publication is sysname, with no default.
The type of validation to perform. @level is tinyint, and can be one of the following values.
| Level value | Description |
|---|---|
1 |
Rowcount-only validation. |
2 |
Rowcount and checksum validation. For SQL Server 2005 (9.x) Subscribers, this is automatically set to 3. |
3 |
This is the recommended value. |
0 (success) or 1 (failure).
sp_validatemergepublication is used in merge replication.
Only members of the sysadmin fixed server role can execute sp_validatemergepublication.