sp_validatemergepublication (Transact-SQL)
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
Syntax
sp_validatemergepublication
[ @publication = ] N'publication'
, [ @level = ] level
[ ; ]
Arguments
[ @publication = ] N'publication'
The name of the publication. @publication is sysname, with no default.
[ @level = ] level
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. |
Return code values
0
(success) or 1
(failure).
Remarks
sp_validatemergepublication
is used in merge replication.
Permissions
Only members of the sysadmin fixed server role can execute sp_validatemergepublication
.
Related content
Opinia
https://aka.ms/ContentUserFeedback.
Dostępne już wkrótce: W 2024 r. będziemy stopniowo wycofywać zgłoszenia z serwisu GitHub jako mechanizm przesyłania opinii na temat zawartości i zastępować go nowym systemem opinii. Aby uzyskać więcej informacji, sprawdź:Prześlij i wyświetl opinię dla