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.
The datetime that the event occurred.
The unique identification number for a given publication.
The unique identification number for the given article.
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.
The name of the property set or changed
The previous property value if a property was changed.
The value that the property was changed to or created at.
The character string describing the event.