This topic has not yet been rated - Rate this topic

ServiceBroker Class

SQL Server 2008

The ServiceBroker object represents an implementation of Service Broker on a Microsoft SQL Server database.

Namespace: Microsoft.SqlServer.Management.Smo.Broker
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

public sealed class ServiceBroker : SqlSmoObject

Remarks

The ServiceBroker object is the top-level class under which all the Service Broker functionality resides. A Service Broker implementation (services, queues, and message types) is required for each database that is participating in the distributed messaging application.

To get ServiceBroker object properties, users can be a member of the public fixed server role.

To set ServiceBroker object properties, users must be a member of the db_ddladmin or db_owner fixed database roles, or be a member of the sysadmin fixed server role. The user also requires REFERENCES permission on the specified schema.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Examples

Overview [Service Broker]

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.SmoObjectBase
    Microsoft.SqlServer.Management.Smo.SqlSmoObject
      Microsoft.SqlServer.Management.Smo.Broker.ServiceBroker

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.