• Product Information
  • About
  • Product tour
  • News
  • Screenshots
  • Testimonials
• Support Information
  • Documentation
  • FAQ
  • Support
• Download
• Purchase

MS SQL Maestro online Help

Editing message type properties

You can change message type properties here. The detailed description is given below.
 

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.