Choose your database:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
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".
Lynn Armbruster: "Thank you. I found Maestro easy to use and so far a great tool".

More

Add your opinion

Customers
Download Buy

MS SQL Maestro online Help

Prev Return to chapter overview Next

Specifying new message type properties

Specify new message type properties according to your needs. The detailed description is given below.
 

 

Name

The name of the message type to create. The name may be up to 128 characters.

 

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