sys.sp_replsetoriginator

Description

Used to invoke loopback detection and handling in bidirectional transactional replication. This stored procedure is executed at the Publisher on the publication database.

Syntax

sp_replsetoriginator
[ @originator_srv = ]
N
'originator_srv'
, [ @originator_db = ]
N
'originator_db'
[ , [ @publication = ]
N
'publication'
]
[ ; ]

Permissions

is executed by the Distribution Agent to record the source of transactions applied by replication. This information is used to invoke loopback detection for bidirectional transactional subscriptions that have the loopback property set. Only members of the fixed server role at the Publisher, members of the fixed database role on the publication database, or users in the publication access list (PAL) can execute. System stored procedures (Transact-SQL)