Skip to content

Commit fd6ad00

Browse files
authored
loopback_detection update
Remove mention of only including for backward compatibility with SQL 2000 (!). Remove pointer to use peer-to-peer instead of bi-directional (on bi-directional page we say it can outperform P2P - which is true).
1 parent e0067f3 commit fd6ad00

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/relational-databases/system-tables/mssubscriptions-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -39,7 +39,7 @@ ms.author: sstein
3939
|**snapshot_seqno_flag**|**bit**|Indicates the source of the snapshot transaction sequence number, where a value of **1** means that **subscription_seqno** is the snapshot sequence number.|
4040
|**independent_agent**|**bit**|Indicates whether there is a stand-alone Distribution Agent for this publication.|
4141
|**subscription_time**|**datetime**|Internal use only.|
42-
|**loopback_detection**|**bit**|Applies to subscriptions that are part of a bidirectional transactional replication topology. Loopback detection determines whether the Distribution Agent sends transactions originated at the Subscriber back to the Subscriber:<br /><br /> **1** = Does not send back.<br /><br /> **0** = Sends back.<br /><br /> Note: This column is supported only for backward compatibility with the bi-directional replication functionality in [!INCLUDE[ssVersion2000](../../includes/ssversion2000-md.md)]. For later versions of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], peer-to-peer replication should be used instead. For more information, see [Peer-to-Peer Transactional Replication](../../relational-databases/replication/transactional/peer-to-peer-transactional-replication.md).|
42+
|**loopback_detection**|**bit**|Applies to subscriptions that are part of a bidirectional transactional replication topology. Loopback detection determines whether the Distribution Agent sends transactions originated at the Subscriber back to the Subscriber:<br /><br /> **1** = Does not send back.<br /><br /> **0** = Sends back.<br /><br />|
4343
|**agent_id**|**int**|The ID of the agent.|
4444
|**update_mode**|**tinyint**|The type of update.|
4545
|**publisher_seqno**|**varbinary(16)**|The sequence number of the transaction at the Publisher for this subscription.|

0 commit comments

Comments
 (0)