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 為共用) 成員具備多執行緒作業安全。並非所有的執行個體成員都是安全執行緒。
範例
CREATE BROKER PRIORITY (Transact-SQL)
執行緒安全性
這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。
請參閱
參考
Microsoft.SqlServer.Management.Smo.Broker 命名空間
其他資源
CREATE BROKER PRIORITY (Transact-SQL)