共用方式為


ServiceQueue Class

The ServiceQueue object represents a queue that stores messages and after they are received.

命名空間: Microsoft.SqlServer.Management.Smo.Broker
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
Public NotInheritable Class ServiceQueue
    Inherits ScriptSchemaObjectBase
    Implements IObjectPermission, IExtendedProperties, ICreatable, IAlterable, _
    IDroppable, IScriptable
public sealed class ServiceQueue : ScriptSchemaObjectBase, IObjectPermission, IExtendedProperties, ICreatable, 
    IAlterable, IDroppable, IScriptable
public ref class ServiceQueue sealed : public ScriptSchemaObjectBase, IObjectPermission, IExtendedProperties, ICreatable, 
    IAlterable, IDroppable, IScriptable
public final class ServiceQueue extends ScriptSchemaObjectBase implements IObjectPermission, IExtendedProperties, 
    ICreatable, IAlterable, IDroppable, IScriptable
public final class ServiceQueue extends ScriptSchemaObjectBase implements IObjectPermission, IExtendedProperties, 
    ICreatable, IAlterable, IDroppable, IScriptable

備註

The ServiceQueue object provides asynchronous communication between services, as well as other benefits, such as automatically locking messages in the same conversation group.

只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。

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

To set ServiceQueue 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.

To create a service queue, 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.

To drop a service queue, 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.

To receive a message, users must have RECEIVE permission on the service queue.

To grant, deny, or revoke permissions on the message type to other users, users must have CONTROL permission on the service queue.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Management.Smo.SmoObjectBase
     Microsoft.SqlServer.Management.Smo.SqlSmoObject
       Microsoft.SqlServer.Management.Smo.NamedSmoObject
         Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase
           Microsoft.SqlServer.Management.Smo.ScriptSchemaObjectBase
            Microsoft.SqlServer.Management.Smo.Broker.ServiceQueue

範例

Readme_ServiceBrokerConfiguration

執行緒安全性

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

平台

開發平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

目標平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

請參閱

參考

ServiceQueue Members
Microsoft.SqlServer.Management.Smo.Broker Namespace

其他資源

Service Broker Programming
Managing Service Broker
Service Broker 簡介
CREATE QUEUE (Transact-SQL)