MSmerge_settingshistory (Transact-SQL)
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. |
See Also
Concepts
Replication Tables (Transact-SQL)