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

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

SQL Server 2000

Specifies a valid Transact-SQL expression that provides the protocol field value.

Structure

<NotificationClasses>
   <NotificationClass>
      ...
      <Protocols>
         <Protocol>
            ...
            <Fields>
               <Field>
                  ...
                  <SqlExpression>

Element Characteristics

Characteristic	Description
Data Type	string, between 0 and 4,000 characters in length.
Default Value	None.
Occurrence	Optional once per /NotificationClasses/NotificationClass/Protocols/Protocol/Fields/Field node.
Updates	Can be modified, but not added or deleted, using NSControl Update.

Element Relationships

Relationship	Elements
Parent Node	<Field> Node (/Protocol/Fields)

Remarks

If you update a <SqlExpression> element, NSControl Update deletes and re-creates the notification class to which it corresponds. This includes dropping and re-creating the SQL Server tables used by this notification class.

Important If you update a <SqlExpression> element, any data existing in the original SQL Server tables is permanently deleted.

Important If a <SqlExpression> element is not included in the <Field> node, a <FieldReference> element must be provided instead.

See Also

Documenting the Delivery Protocols

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.