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)