Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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

SQL Server 2000

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


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)

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
© 2015 Microsoft