BrokerPriority 类
The BrokerPriority object represents a priority level and the set of criteria for determining which Service Broker conversations to assign the priority level.
继承层次结构
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.Broker.BrokerObjectBase
Microsoft.SqlServer.Management.Smo.Broker.BrokerPriority
命名空间: Microsoft.SqlServer.Management.Smo.Broker
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources", _
True)> _
Public NotInheritable Class BrokerPriority _
Inherits BrokerObjectBase _
Implements IObjectPermission, ICreatable, IAlterable, IDroppable, _
IScriptable
用法
Dim instance As BrokerPriority
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources",
true)]
public sealed class BrokerPriority : BrokerObjectBase,
IObjectPermission, ICreatable, IAlterable, IDroppable, IScriptable
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute]
[LocalizedPropertyResourcesAttribute(L"Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources",
true)]
public ref class BrokerPriority sealed : public BrokerObjectBase,
IObjectPermission, ICreatable, IAlterable, IDroppable, IScriptable
[<SealedAttribute>]
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources",
true)>]
type BrokerPriority =
class
inherit BrokerObjectBase
interface IObjectPermission
interface ICreatable
interface IAlterable
interface IDroppable
interface IScriptable
end
public final class BrokerPriority extends BrokerObjectBase implements IObjectPermission, ICreatable, IAlterable, IDroppable, IScriptable
BrokerPriority 类型公开以下成员。
构造函数
名称 | 说明 | |
---|---|---|
BrokerPriority() | Initializes a new instance of the BrokerPriority class. | |
BrokerPriority(ServiceBroker, String) | Initializes a new instance of the BrokerPriority class on the specified implementation of Service Broker and with the specified name. |
页首
属性
名称 | 说明 | |
---|---|---|
ContractName | Gets or sets the contract name specified for the BrokerPriority object. | |
ID | Gets the conversation priority ID associated with the BrokerPriority object. | |
LocalServiceName | Gets or sets the local service name associated with the BrokerPriority object. | |
Name | Gets or sets the name of the object. (从 BrokerObjectBase 继承。) | |
Parent | Gets or sets the ServiceBroker object that is the parent of the BrokerPriority object | |
PriorityLevel | Gets or sets the priority level associated with the BrokerPriority object. | |
Properties | Gets a collection of Property objects that represent the object properties. (从 SqlSmoObject 继承。) | |
RemoteServiceName | Gets or sets the remote service name associated with the BrokerPriority object. | |
State | Gets the state of the referenced object. (从 SmoObjectBase 继承。) | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (从 SqlSmoObject 继承。) | |
UserData | Gets or sets user-defined data associated with the referenced object. (从 SmoObjectBase 继承。) |
页首
方法
名称 | 说明 | |
---|---|---|
Alter | Updates a conversation priority in an instance of SQL Server with any property changes made in the specified BrokerPriority object. | |
Create | Creates a conversation priority on the instance of Microsoft SQL Server as defined by the BrokerPriority object. | |
Deny(ObjectPermissionSet, String) | This method will be removed in a future version of the product.Denies access to the specified permission for the specified grantees on the conversation priority. | |
Deny(ObjectPermissionSet, array<String[]) | This method will be removed in a future version of the product.Denies access to the specified permission for the specified grantees on the conversation priority. | |
Deny(ObjectPermissionSet, String, Boolean) | This method will be removed in a future version of the product.Denies access to the specified permission for the specified grantee and other users that the grantee granted access to on the conversation priority. | |
Deny(ObjectPermissionSet, array<String[], Boolean) | This method will be removed in a future version of the product.Denies access to the specified permission for the specified grantee and other users that the grantee granted access to on the conversation priority. | |
Discover | Discovers a list of type Object. (从 SqlSmoObject 继承。) | |
Drop | Removes the conversation priority. | |
EnumObjectPermissions() | This method will be removed in a future version of the product.Enumerates a list of object permissions for the conversation priority. | |
EnumObjectPermissions(String) | This method will be removed in a future version of the product.Enumerates a list of object permissions for a specified grantee on the conversation priority. | |
EnumObjectPermissions(ObjectPermissionSet) | This method will be removed in a future version of the product.Enumerates a list of object permissions for a specified permission on the conversation priority. | |
EnumObjectPermissions(String, ObjectPermissionSet) | This method will be removed in a future version of the product.Enumerates a list of object permissions for a specified grantee and a specified permission on the conversation priority. | |
Equals | (从 Object 继承。) | |
FormatSqlVariant | Formats an object as SqlVariant type. (从 SqlSmoObject 继承。) | |
GetContextDB | Gets the context database that is associated with this object. (从 SqlSmoObject 继承。) | |
GetDBName | Returns the name of the database on which the instance of Service Broker is implemented. (从 BrokerObjectBase 继承。) | |
GetHashCode | (从 Object 继承。) | |
GetPropValue | Gets a property value of the SqlSmoObject object. (从 SqlSmoObject 继承。) | |
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (从 SqlSmoObject 继承。) | |
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (从 SqlSmoObject 继承。) | |
GetServerObject | Gets the server of the SqlSmoObject object. (从 SqlSmoObject 继承。) | |
GetType | (从 Object 继承。) | |
Grant(ObjectPermissionSet, String) | This method will be removed in a future version of the product.Grants access to the specified permission for the specified grantees on the conversation priority. | |
Grant(ObjectPermissionSet, array<String[]) | This method will be removed in a future version of the product.Grants access to the specified permission for the specified grantees on the conversation priority. | |
Grant(ObjectPermissionSet, String, Boolean) | This method will be removed in a future version of the product.Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the conversation priority. | |
Grant(ObjectPermissionSet, array<String[], Boolean) | This method will be removed in a future version of the product.Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the conversation priority. | |
Grant(ObjectPermissionSet, String, Boolean, String) | This method will be removed in a future version of the product.Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the conversation priority. | |
Grant(ObjectPermissionSet, array<String[], Boolean, String) | This method will be removed in a future version of the product.Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the conversation priority. | |
Initialize() | Initializes the object and forces the properties be loaded. (从 SqlSmoObject 继承。) | |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (从 SqlSmoObject 继承。) | |
IsObjectInitialized | Verifies whether the object has been initialized. (从 SqlSmoObject 继承。) | |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (从 SqlSmoObject 继承。) | |
Refresh | Refreshes the script name. (从 ScriptNameObjectBase 继承。) | |
Revoke(ObjectPermissionSet, String) | This method will be removed in a future version of the product.Revokes previously granted permissions from a grantee on the conversation priority. | |
Revoke(ObjectPermissionSet, array<String[]) | This method will be removed in a future version of the product.Revokes previously granted permissions from a grantee on the conversation priority. | |
Revoke(ObjectPermissionSet, String, Boolean, Boolean) | This method will be removed in a future version of the product.Revokes previously granted permissions from a grantee on the conversation priority and any other users to whom the grantee has granted access. The grantee is also given the ability to revoke other users' access. | |
Revoke(ObjectPermissionSet, array<String[], Boolean, Boolean) | This method will be removed in a future version of the product.Revokes previously granted permissions from a grantee on the conversation priority and any other users to whom the grantee has granted access. The grantee is also given the ability to revoke other users' access. | |
Revoke(ObjectPermissionSet, String, Boolean, Boolean, String) | This method will be removed in a future version of the product.Revokes previously granted permissions from a grantee on the conversation priority and any other users to whom the grantee has granted access. The grantee is also given the ability to revoke other users' access. | |
Revoke(ObjectPermissionSet, array<String[], Boolean, Boolean, String) | This method will be removed in a future version of the product.Revokes previously granted permissions from a grantee on the conversation priority and any other users to whom the grantee has granted access. The grantee is also given the ability to revoke other users' access. | |
Script() | Generates a Transact-SQL script that can be used to re-create the Service Broker object. (从 BrokerObjectBase 继承。) | |
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the SQL Server Agent alert as specified by the scripting options. (从 BrokerObjectBase 继承。) | |
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (从 SqlSmoObject 继承。) | |
ToString | Returns a String that represents the referenced object. (从 SqlSmoObject 继承。) | |
Validate | Validates the state of an object. (从 SmoObjectBase 继承。) |
页首
事件
名称 | 说明 | |
---|---|---|
PropertyChanged | Represents the event that occurs when a property is changed. (从 SqlSmoObject 继承。) | |
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (从 SqlSmoObject 继承。) |
页首
显式接口实现
名称 | 说明 | |
---|---|---|
IAlienObject.Discover | Discovers any dependencies. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) | |
IAlienObject.GetDomainRoot | Returns the root of the domain. (从 SqlSmoObject 继承。) | |
IAlienObject.GetParent | Gets the parent of this object. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) | |
IAlienObject.GetPropertyType | Gets the type of the specified property. (从 SqlSmoObject 继承。) | |
IAlienObject.GetPropertyValue | Gets the value of the specified property. (从 SqlSmoObject 继承。) | |
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) | |
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (从 SqlSmoObject 继承。) | |
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (从 SqlSmoObject 继承。) | |
IAlienObject.SetPropertyValue | Sets the property value. (从 SqlSmoObject 继承。) | |
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (从 SqlSmoObject 继承。) |
页首
注释
To get BrokerPriority object properties, users can be a member of the public fixed server role.
To set BrokerPriority 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 ALTER permission on the database.
To create a conversation priority, 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 ALTER permission on the database.
To drop a conversation priority, 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 ALTER permission on the database.
注意 |
---|
In a future release of SQL Server, BrokerPriority will no longer implement IObjectPermission. |
Thread Safety
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。
示例
CREATE BROKER PRIORITY (Transact-SQL)
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。
请参阅
参考
Microsoft.SqlServer.Management.Smo.Broker 命名空间
其他资源
CREATE BROKER PRIORITY (Transact-SQL)