This topic has not yet been rated - Rate this topic

Message Schemas for Query Notification

The Microsoft BizTalk Adapter for SQL Server surfaces the Notification operation to receive query notifications from the SQL Server database.

You configure the Notification operation by setting binding properties in the SQL adapter. For more information about the Notification-related binding properties, see Working with BizTalk Adapter for SQL Server Binding Properties. You set the NotificationStatement binding property to specify a SQL statement (SELECT or EXEC <stored procedure>) for the query notification. The result set of this query is returned as strongly-typed data to your code in the Notification operation.

Message Structure for the Notification Operation

The following table shows the XML message structure for the Notification operation.

Operation XML Message Description

Operation	XML Message	Description
Notification	Copy <?xml version="1.0" encoding="utf-8" ?> <Notification xmlns="http://schemas.microsoft.com/Sql/2008/05/Notification"> <Info>Value</Info> <Source>Value</Source> <Type>Value</Type> </Notification>	This is the inbound message that is sent by the SQL Server to the adapter clients. In the message: The `<Info>` tag indicates the reason for the notification. For example, an “insert” value in this tag indicates that data has been inserted in one or more of the tables referenced in the notification statement. The `<Source>` tag indicates the source for the notification. For example, a “data” value in this tag indicates a change in the data in a referenced object. Similarly, an “object” value in this tag indicates a change in a referenced object. The `<Type>` tag indicates the type of data change. Query notification messages are of two types: change and subscribe. A “change” value in the `<Type>` tag indicates that the results of the query have changed, whereas a “subscribe” value in the `<Type>` tag indicates that a subscription request failed. For more information about the query notification message tags, see the “Properties” section at http://go.microsoft.com/fwlink/?LinkId=122393.

Notification

<?xml version="1.0" encoding="utf-8" ?> 
<Notification xmlns="http://schemas.microsoft.com/Sql/2008/05/Notification">
   <Info>Value</Info>
   <Source>Value</Source>
   <Type>Value</Type>
</Notification>

This is the inbound message that is sent by the SQL Server to the adapter clients. In the message:

The <Info> tag indicates the reason for the notification. For example, an “insert” value in this tag indicates that data has been inserted in one or more of the tables referenced in the notification statement.
The <Source> tag indicates the source for the notification. For example, a “data” value in this tag indicates a change in the data in a referenced object. Similarly, an “object” value in this tag indicates a change in a referenced object.
The <Type> tag indicates the type of data change. Query notification messages are of two types: change and subscribe. A “change” value in the <Type> tag indicates that the results of the query have changed, whereas a “subscribe” value in the <Type> tag indicates that a subscription request failed.

For more information about the query notification message tags, see the “Properties” section at http://go.microsoft.com/fwlink/?LinkId=122393.

Message Action for the Notification Operation

The message action for the notification operation is “Notification.”

Other Resources

Technical Reference

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)