Export (0) Print
Expand All
Expand Minimize

<SqlStatement> Element (/SubscriptionClass/Chronicles/Chronicle/SqlSchema)

SQL Server 2000

Specifies a Transact-SQL statement to create a SQL Server subscription chronicle table.

Structure
<SubscriptionClasses>
   <SubscriptionClass>
      ...
      <Chronicles>
         <Chronicle>
            ...
            <SqlSchema>
               <SqlStatement>

Element Characteristics
Characteristic Description
Data Type string, between 1 and 100,000 characters in length.
Default Value None.
Occurrence Optional once or more per <SqlSchema> node.
Updates Can be added, deleted, and modified using NSControl Update.
Element Relationships
Remarks

If you add, delete, or update a <SqlStatement> element, NSControl Update deletes the old chronicle table and creates a new, empty chronicle table. The data from the old chronicle table is permanently deleted.

See Also
Defining Chronicle Tables
Show:
© 2014 Microsoft