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

Subscribe to our news:
Partners
Testimonials
DavidNR: "MS SQL Maestro is a great app. Loved it. I only used it for its blob support thus far, very nice and very fast".
Lynn Armbruster: "Thank you. I found Maestro easy to use and so far a great tool".

More

Add your opinion

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