Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Kevin Settler: "If you need the job done right and on time, do it with MS SQL Maestro on your team. The software is a pleasure for us. SQL Maestro Group do excellent work and are dedicated to producing products that all can be proud of".
Albert Rognan: "Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".

More

Add your opinion

Customers
Download Buy

MS SQL Maestro online Help

Prev Return to chapter overview Next

Editing message type properties

The Name field displays the message type name.

 

Owner

Sets the owner of the message type to the specified database user or role. When the current user is dbo or sa, the Owner may be the name of any valid user or role. Otherwise, Owner must be the name of the current user, the name of a user that the current user has impersonate permissions for, or the name of a role to which the current user belongs. In case the field is blanck the message type belongs to the current user.

 

Validation type

Specifies how Service Broker validates the message body for messages of this type.

None

No validation is performed. The message body may contain any data, or may be NULL.

Empty

The message body must be NULL.

XML

The message body must contain well-formed XML.

 

XML Schema Collection

The message body must contain XML that conforms to a schema in the specified schema collection The XML Schema Collection must be the name of an existing XML schema collection.



Prev Return to chapter overview Next