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 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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho