Service Broker Assistant - Product Spotlight
SQL Server Asychronous Messaging Addin
Create and modify SQL Service Broker applications quickly...
Right from the object explorer in SQL Server Management Studio, right-click the object you want to create or modify. Create applications in minutes without writing a single line of T-SQL code.
Manage SQL Service Broker easily...
From a single configuration screen, you can:
• Enable Service Broker on any instance
• Enable and configure Service Broker Networking
• Setup dialog security and create certificates
• Activate conversation errors
...and more!
No scripting...unless you want to!
Of course, if you need to generate scripts of any action performed within Service Broker Assistant, included is a simple, automatic scripting toolbar. Script actions to a new query window, save to a file or copy to the clipboard.
Quick Shots
Product Detail
Service Broker Assistant Standard Edition is a SQL Server Management Studio add-in that helps in the creation and modification of Service Broker objects. From creating service dependent objects like queues and contracts, to configuring each database instance of Service Broker. Service Broker Assistant also provides support for message types, XML schema collections, remote service bindings and routes. Check out the Feature Comparison for more details.
Service Broker Assistant Standard 2008 Edition is a SQL Server Management Studio add-in that helps in the creation and modification of Service Broker objects. From creating service dependent objects like queues and contracts, to configuring each database instance of Service Broker. Service Broker Assistant also provides support for message types, XML schema collections, remote service bindings and routes. Check out the Feature Comparison for more details.
Service Broker Assistant Professional Edition all the object management features are included from the Standard Edition
as well as the easy-to-use configuration functionality. Added are common administration tasks for quickly creating
and modifying Service Broker applications. Enable network access for you applications with a few clicks. Set up
security options for broker communications. All available from inside SQL Server Management Studio.
Professional Edition also includes management features to help in the daily tasks of administering Service Broker
applications. Perform queue maintenance, monitor performance with counters and tracing events, even detect and remove
poison messages. Create broker conversations quickly and easily. Create event notifications for DDL events that
occur in the database. Check out the Feature Comparison for more details.
Service Broker Assistant Professional 2008 Edition all the object management features are included from the Standard Edition
as well as the easy-to-use configuration functionality. Added are common administration tasks for quickly creating
and modifying Service Broker applications. Enable network access for you applications with a few clicks. Set up
security options for broker communications. All available from inside SSMS.
Professional Edition also includes management features to help in the daily tasks of administering Service Broker
applications. Perform queue maintenance, monitor performance with counters and tracing events, even detect and remove
poison messages. Create broker conversations quickly and easily. Create event notifications for DDL events that
occur in the database. Check out the Feature Comparison for more details.
System Requirements
Product Highlights
SQL Server uses Service Broker endpoints for Service Broker communication outside of the SQL Server instance.
An endpoint is a SQL Server object that represents the capability for SQL Server to communicate over the network. Each endpoint supports a specific type of communication.
A Service Broker endpoint configures SQL Server to send and receive Service Broker messages over the network.
Service Broker endpoints provide options for transport security and message forwarding. A Service Broker endpoint listens on a specific TCP port number.
By default, an instance of SQL Server does not contain a Service Broker endpoint. Thus, Service Broker does not send or receive messages over the network by default.
You must create a Service Broker endpoint to send or receive messages outside the SQL Server instance.
A contract defines which message types an application uses to accomplish a particular task.
It is an agreement between two services about which messages each service sends to accomplish a particular task.
You create an identical contract in each database that participates in a conversation.
The contract specifies which message types can be used to accomplish the desired work.
The contract also specifies which participant in the conversation can use each message type.
Service Broker Assistant (SBA) makes configuring your Service Broker instance and applications quick and easy.
From enabling and disabling the instance to pause and resume functionality.
SBA also makes securing Service Broker applications
and network access simple.
• Activate conversation errors
• Configure full and anonymous dialog security
• Activate and deactivate Service Broker networking
• Implement Windows and certificate based network access