| title | MSmerge_settingshistory (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | replication | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 0bdf2d5f-5502-44cd-aa9d-2d5006ad20ce | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
The MSmerge_settingshistory table is used to maintain a history of changes made to article and publication properties for merge replication, with one row for each change made to a merge replication topology. This table also stores information about when the initial property settings were made. This table is stored in the publication and subscription databases.
| Column name | Data type | Description |
|---|---|---|
| eventtime | datetime | The datetime that the event occurred. |
| pubid | uniqueidentifier | The unique identification number for a given publication. |
| artid | uniqueidentifier | The unique identification number for the given article. |
| eventtype | tinyint | Specifies the type of event being recorded, which can be one of the following: 1 - initial publication level property setting. 2 - change in a publication property. 101 - initial article property setting. 102 - change in an article property. |
| propertyname | sysname | The name of the property set or changed |
| previousvalue | sysname | The previous property value if a property was changed. |
| newvalue | sysname | The value that the property was changed to or created at. |
| eventtext | nvarchar(2000) | The character string describing the event. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)