MSmerge_settingshistory (Transact-SQL)


Applies To: 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 nameData typeDescription
eventtimedatetimeThe datetime that the event occurred.
pubiduniqueidentifierThe unique identification number for a given publication.
artiduniqueidentifierThe unique identification number for the given article.
eventtypetinyintSpecifies 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.
propertynamesysnameThe name of the property set or changed
previousvaluesysnameThe previous property value if a property was changed.
newvaluesysnameThe value that the property was changed to or created at.
eventtextnvarchar(2000)The character string describing the event.

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

Community Additions