United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2000

SQL Server 2000 Notification Services Books Online

Programming Reference

Application Definition File Reference

Reserved Characters

The XML Declaration

<Action> Element (<ChronicleRule>)

<Action> Element (<EventRule>)

<Action> Element (<ScheduledRule>)

<ActionTimeout> Element (<ChronicleRule>)

<ActionTimeout> Element (<EventRule>)

<ActionTimeout> Element (<ScheduledRule>)

<Application> Node

<ApplicationExecutionSettings> Node

<Argument> Node (/ContentFormatter/Arguments)

<Argument> Node (/HostedProvider/Arguments)

<Arguments> Node (<ContentFormatter>)

<Arguments> Node (<HostedProvider>)

<AssemblyName> Element (<ContentFormatter>)

<AssemblyName> Element (<HostedProvider>)

<Build> Element

<Chronicle> Node (/EventClass/Chronicles)

<Chronicle> Node (/SubscriptionClass/Chronicles)

<ChronicleName> Element (/EventClass/Chronicles/Chronicle)

<ChronicleName> Element (/SubscriptionClass/Chronicles/Chronicle)

<ChronicleQuantumLimit> Element

<ChronicleRule> Node

<Chronicles> Node (<EventClass>)

<Chronicles> Node (<SubscriptionClass>)

<ClassName> Element (<ContentFormatter>)

<ClassName> Element (<HostedProvider>)

<CollationName> Element

<ComputedField> Node

<ComputedFields> Node

<ContentFormatter> Node

<CreationDate> Element

<CreationTime> Element

<Database> Node

<DefaultFileGroup> Element

<DigestDelivery> Element

<DigestGrouping> Element (<ComputedField>)

<DigestGrouping> Element (<Field>)

<Distributor> Node

<DistributorLogging> Node

<Distributors> Node

<Duration> Element

<EventClass> Node

<EventClasses> Node

<EventClassName> Element (<EventClass>)

<EventClassName> Element (<EventRule>)

<EventRule> Node

<EventRules> Node

<EventThrottle> Element

<ExpirationAge> Element

<FailureEventLogInterval> Element

<FailuresBeforeAbort> Element

<FailuresBeforeLoggingEvent> Element

<Field> Node (/EventClass/Schema)

<Field> Node (/Protocol/Fields)

<Field> Node (/Schema/Fields)

<Field> Node (/SubscriptionClass/Schema)

<FieldName> Element (/EventClass/Schema/Field)

<FieldName> Element (/NotificationClass/Schema/ComputedFields/ComputedField)

<FieldName> Element (/NotificationClass/Schema/Fields/Field)

<FieldName> Element (/Protocol/Fields/Field)

<FieldName> Element (/SubscriptionClass/Schema/Field)

<FieldReference> Element

<Fields> Node (<Protocol>)

<Fields> Node (<Schema>)

<FieldType> Element (/EventClass/Schema/Field)

<FieldType> Element (/NotificationClass/Schema/Fields/Field)

<FieldType> Element (/SubscriptionClass/Schema/Field)

<FieldTypeMods> Element (/EventClass/Schema/Field)

<FieldTypeMods> Element (/SubscriptionClass/Schema/Field)

<FileGroup> Element (<EventClass>)

<FileGroup> Element (<NotificationClass>)

<FileGroup> Element (<SubscriptionClass>)

<FileGroupName> Element

<FileName> Element (<FileSpec>)

<FileName> Element (<LogFile>)

<FileSpec> Node

<Generator> Node

<GrowthIncrement> Element (<FileSpec>)

<GrowthIncrement> Element (<LogFile>)

<HostedProvider> Node

<IndexSqlSchema> Node (<EventClass>)

<IndexSqlSchema> Node (<SubscriptionClass>)

<Interval> Element

<LastModifiedDate> Element

<LastModifiedTime> Element

<LogBeforeDeliveryAttempts> Element

<LogicalName> Element (<FileSpec>)

<LogicalName> Element (<LogFile>)

<LogNotificationText> Element

<LogStatusInfo> Element

<Major> Element

<MaxSize> Element (<FileSpec>)

<MaxSize> Element (<LogFile>)

<Minor> Element

<MulticastDelivery> Element

<MulticastRecipientLimit> Element

<Name> Element (/ContentFormatter/Arguments/Argument)

<Name> Element (/HostedProvider/Arguments/Argument)

<Name> Element (<Parameter>)

<NamedFileGroup> Node

<NonHostedProvider> Node

<NotificationBatchSize> Element

<NotificationClass> Node

<NotificationClasses> Node

<NotificationClassName> Element

<NotificationThrottle> Element

<Parameter> Node

<ParameterDefaults> Node

<PerformanceQueryInterval> Element

<ProcessEventsInOrder> Element

<Protocol> Node

<ProtocolExecutionSettings> Node

<ProtocolName> Element

<Protocols> Node

<ProviderName> Element (<HostedProvider>)

<ProviderName> Element (<NonHostedProvider>)

<Providers> Node

<QuantumDuration> Element (<ApplicationExecutionSettings>)

<QuantumDuration> Element (<Distributor>)

<RetentionAge> Element

<RetryDelay> Element

<RetrySchedule> Node

<Revision> Element

<RuleName> Element (<ChronicleRule>)

<RuleName> Element (<EventRule>)

<RuleName> Element (<ScheduledRule>)

<Schedule> Node (<HostedProvider>)

<Schedule> Node (<VacuumSchedule>)

<ScheduledRule> Node

<ScheduledRules> Node

<Schema> Node (<EventClass>)

<Schema> Node (<NotificationClass>)

<Schema> Node (<SubscriptionClass>)

<Size> Element (<FileSpec>)

<Size> Element (<LogFile>)

<SqlExpression> Element (<ComputedField>)

<SqlExpression> Element (/Protocol/Fields/Field)

<SqlSchema> Node (/EventClass/Chronicles/Chronicle)

<SqlSchema> Node (/SubscriptionClass/Chronicles/Chronicle)

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

<SqlStatement> Element (/EventClass/IndexSqlSchema)

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

<SqlStatement> Element (/SubscriptionClass/IndexSqlSchema)

<StartTime> Element (/HostedProvider/Schedule)

<StartTime> Element (/VacuumSchedule/Schedule)

<SubscriptionClass> Node

<SubscriptionClasses> Node

<SubscriptionClassName> Element

<SubscriptionThrottle> Element

<SubscriptionQuantumLimit> Element

<SystemName> Element (<Distributor>)

<SystemName> Element (<Generator>)

<SystemName> Element (<HostedProvider>)

<ThreadPoolSize> Element (<Distributor>)

<ThreadPoolSize> Element (<Generator>)

<Vacuum> Node

<VacuumSchedule> Node

<Value> Element (/ContentFormatter/Arguments/Argument)

<Value> Element (/HostedProvider/Arguments/Argument)

<Value> Element (<Parameter>)

<WorkItemTimeout> Element

Minimize

This topic has not yet been rated - Rate this topic

<Chronicles> Node (<EventClass>)

SQL Server 2000

Provides a location for defining one or more Transact-SQL statements that determine the table structure for the chronicle tables used by the event class.

Structure

<EventClasses>
   <EventClass>
      ...
      <Chronicles>

Node Characteristics

Characteristic	Description
Occurrence	Optional once per <EventClass> node.
Updates	Can be added and deleted using NSControl Update.

Node Relationships

Relationship	Elements
Parent Node	<EventClass> Node
Child Elements	<Chronicle> Node (/EventClass/Chronicles)

Remarks

If you add or delete the <Chronicles> node, NSControl Update deletes and re-creates the event class to which it corresponds. This includes dropping and re-creating the SQL Server tables and indexes used by this event class.

Important When you add or delete the <Chronicles> node, any data existing in the original SQL Server tables is permanently deleted.

See Also

Event Chronicles

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.