Services (SQL Server)

Services are specific tasks or set of tasks. Service Broker uses the name of the service to route messages, deliver messages to the correct queue within a database, and enforce the contract for a conversation. PowerDesigner models services as extended objects with a stereotype of <<Service>>.

Creating a Service

You can create a service in any of the following ways:

Select Model > Services to access the List of Services, and click the Add a Row tool.
Right-click the model (or a package) in the Browser, and select New > Service.

Service Properties

You can modify an object's properties from its property sheet. To open a service property sheet, double-click its Browser entry.

The following extended attributes are available on the Microsoft tab:

Name	Description
Authorization	Specifies the owner of the service. Scripting name: Owner
Queue	Specifies the queue that receives messages for the service. The queue must exist in the same database as the service. Scripting name: Queue

Name

Description

Authorization

Specifies the owner of the service.

Scripting name: Owner

Queue

Specifies the queue that receives messages for the service. The queue must exist in the same database as the service.

Scripting name: Queue

The Contracts tab lists the contracts with which the service is associated.