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

sp_help_peerconflictdetection (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).

Returns information about the conflict detection settings for a publication that is involved in a peer-to-peer transactional replication topology.

Topic link icon Transact-SQL Syntax Conventions

sp_help_peerconflictdetection [ @publication = ] 'publication'
    [ ,[ @timeout = ] timeout ]

[ @publication= ] 'publication'

Is 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 will time out while waiting for response from every node in the topology. If there is a read-only Subscriber in the topology, specifying a time-out value is not valid. Read-only Subscribers will never respond to a call from this procedure. timeout is int, with a default of 60.

sp_help_peerconflictdetection returns three result sets. These results are documented in the following topics:

0 (success) or 1 (failure)

sp_help_peerconflictdetection is used in peer-to-peer transactional replication.

Requires membership in the sysadmin fixed server role or db_owner fixed database role.

Community Additions

© 2016 Microsoft