Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sysmergeschemachange

SQL Server 2000

Contains information about the published articles generated by the Snapshot Agent. This table is stored in the publication and subscription databases.

Column name Data type Description
pubid uniqueidentifier ID of the publication
artid uniqueidentifier ID of the article
schemaversion int Number of the last schema change
schemaguid uniqueidentifier Unique ID of the last schema
schematype int Type of schema:

1 = Schema
2 = System schema
3 = Trigger script

schematext nvarchar(255) Name of the script file, or a command which includes a file name

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.