MSrepl_originators (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The MSrepl_originators table contains one row for each updatable Subscriber from which the transaction originated. This table is stored in the distribution database.

Column name Data type Description
id int Identifies the updating Subscriber.
publisher_database_id int Identifies the publication database.
srvname sysname The name of the updating server.
dbname sysname The name of the updating database.
publication_id int Identifies the publication.
dbversion int Identifies the database version.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)