msrepl-originators-transact-sql.md

title	MSrepl_originators (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server
f1_keywords	MSrepl_originators_TSQL MSrepl_originators
dev_langs	TSQL
helpviewer_keywords	MSrepl_originators system table
ms.assetid	a3ac20a6-73f6-4fdc-ad5f-5f72746c9871
caps.latest.revision	26
author	BYHAM
ms.author	rickbyh
manager	jhubbard

MSrepl_originators (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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)