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

Download Buy

MS SQL Maestro online Help

Editing conversation properties

Initiator service

Specifies the service that initiates the dialog. The name specified must be the name of a service in the current database. The queue specified for the initiator service receives messages returned by the target service and messages created by Service Broker for this conversation.

Target service

Specifies the target service with which to initiate the dialog. The target_service_name is of type nvarchar(256). Service Broker uses a byte-by-byte comparison to match the target_service_name string. In other words, the comparison is case-sensitive and does not take into account the current collation.

Contract

Specifies the contract that this conversation follows. The contract must exist in the current database. If the target service does not accept new conversations on the contract specified, Service Broker returns an error message on the conversation.

Related conversation

Specifies the existing conversation group that the new dialog is added to. When this clause is present, the new dialog belongs to the same conversation group as the dialog specified by related conversation. The conversation must be of a type implicitly convertible to type uniqueidentifier.

Related conversation group

Specifies the existing conversation group that the new dialog is added to. When this clause is present, the new dialog will be added to the conversation group specified by related conversation group.

Life time

Specifies the maximum amount of time the dialog will remain open. For the dialog to complete successfully, both endpoints must explicitly end the dialog before the lifetime expires. The lifetime value must be expressed in seconds. Lifetime is of type int.

Encryption

Specifies whether or not messages sent and received on this dialog must be encrypted when they are sent outside of a Microsoft SQL Server instance. A dialog that must be encrypted is a secured dialog. When unchecked and the certificates required to support encryption are not configured, Service Broker returns an error message on the conversation. If checked, encryption is used if a remote service binding is configured for the target service; otherwise messages are sent unencrypted.