MSmerge_settingshistory (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)