FieldName Element for NotificationClass/Schema/Fields/Field (ADF)

FieldName Element for NotificationC...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

SQL Server 2005 Books Online (November 2008)

FieldName Element for NotificationClass/Schema/Fields/Field (ADF)

Specifies the user-defined name of the notification field.

Syntax

<NotificationClasses>
    <NotificationClass>
        ...
        <Schema>
            <Fields>
                <Field>
                    <FieldName>

Element Characteristics

Characteristic	Description
Data type	string, between 1 and 128 characters in length.
Default value	None.
Occurrence	Required once per Field element.
Updates	Can be modified, but not added or deleted, when updating the application.

Element Relationships

Relationship	Elements
Parent element	Field Element for Schema/Fields (ADF)
Child elements	None.

Remarks

Field names can contain letters, numbers, and the special characters _, #, @, and $. They must also conform to Microsoft SQL Server identifier conventions. For more information about SQL Server identifiers, see Identifiers.

SQL Server 2005 Notification Services reserves the following field names. Do not create notification fields with these names:

DeliveryChannelName
DeliveryStatusCode
DeviceAddress
DeviceName
DeviceTypeName
DistributorWorkItemId
ExpirationTime
LinkNotificationId
NotificationId
NotificationBatchId
SentTime
SubscriberId
SubscriberLocale

Important:
If you update a FieldName element, updating the application 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. Any data existing in the original notification class tables is permanently deleted.

Example

The following example shows a FieldName element.

<FieldName>StockPrice</FieldName>

Reference

Other Resources

Help and Information