Dela via


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.