Working with message properties

When a message is read, the message header and user properties can be processed by Transact-SQL application logic, using built-in SQL functions. These functions return:

• The name of the n^th property

• The value of a named property

• The type of a named property

• The number of properties

• A list of the properties

These built-in functions allow application logic to make processing decisions during runtime, based on the value of the message properties:

• msgproplist

• msgpropname

• msgpropvalue

• msgproptype

• msgpropcount