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.|