sp_help_peerconflictdetection (Transact-SQL)
Applies to:
SQL Server
Returns information about the conflict detection settings for a publication that is involved in a peer-to-peer transactional replication topology.
Transact-SQL syntax conventions
Syntax
sp_help_peerconflictdetection
[ @publication = ] N'publication'
[ , [ @timeout = ] timeout ]
[ ; ]
Arguments
[ @publication = ] N'publication'
The name of the publication for which to return information. @publication is sysname, with no default.
[ @timeout = ] timeout
Specifies the amount of time, in seconds, after which the procedure times out while waiting for response from every node in the topology. @timeout is int, with a default of 60
. If there's a read-only Subscriber in the topology, specifying a time-out value isn't valid. Read-only Subscribers never respond to a call from this procedure.
Result set
sp_help_peerconflictdetection
returns three result sets. These results are documented in the following articles:
- MSpeer_conflictdetectionconfigrequest (Transact-SQL)
- MSpeer_conflictdetectionconfigresponse (Transact-SQL)
- MSpeer_originatorid_history (Transact-SQL)
Return code values
0
(success) or 1
(failure).
Remarks
sp_help_peerconflictdetection
is used in peer-to-peer transactional replication.
Permissions
Requires membership in the sysadmin fixed server role, or db_owner fixed database role.
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें