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

<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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.