| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSmerge_settingshistory (Transact-SQL) |
MSmerge_settingshistory (Transact-SQL) |
VanMSFT |
vanto |
03/04/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
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)