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)
Opinia
https://aka.ms/ContentUserFeedback.
Dostępne już wkrótce: W 2024 r. będziemy stopniowo wycofywać zgłoszenia z serwisu GitHub jako mechanizm przesyłania opinii na temat zawartości i zastępować go nowym systemem opinii. Aby uzyskać więcej informacji, sprawdź:Prześlij i wyświetl opinię dla