| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSpeer_originatorid_history (Transact-SQL) |
MSpeer_originatorid_history (Transact-SQL) |
VanMSFT |
vanto |
03/04/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
Contains one row for each originator ID that has been defined in the topology. This includes IDs for nodes that are no longer active. The table is used when you are configuring a new node for conflict detection to ensure that the originator ID specified has not already been used. This table is stored in the publication database. For more information about conflict detection, see Conflict Detection in Peer-to-Peer Replication.
| Column name | Data type | Description |
|---|---|---|
| originator_publication | sysname | Publication for which the originator ID was specified. |
| originator_id | int | Number that identifies each node in the topology for the purposes of conflict detection |
| originator_node | sysname | Server instance for which the originator ID was specified. |
| originator_db | sysname | Publication database for which the originator ID was specified. |
| originator_db_version | int | Identifies the version number of the originating database. |
| originator_version | int | Identifies the version number of the Publisher. |
| inserted_date | datetime | Date and time that the row for the originator ID was inserted into this table. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)