.png)
BrokerPriority Class
SQL Server 2012
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.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
Namespace: Microsoft.SqlServer.Management.Smo.Broker
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)] [TypeConverterAttribute(typeof(LocalizableTypeConverter))] [PhysicalFacetAttribute] [LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources", true)] public sealed class BrokerPriority : BrokerObjectBase, IObjectPermission, ICreatable, IAlterable, IDroppable, IScriptable
The BrokerPriority type exposes the following members.
| Name | Description | |
|---|---|---|
 | 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. |
| Name | Description | |
|---|---|---|
| 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. (Inherited from 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. (Inherited from SqlSmoObject.) |
| RemoteServiceName | Gets or sets the remote service name associated with the BrokerPriority object. |
| State | Gets the state of the referenced object. (Inherited from SmoObjectBase.) |
| Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.) |
| UserData | Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.) |
| Name | Description | |
|---|---|---|
| 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, 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, 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. (Inherited from 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 | (Inherited from Object.) |
| FormatSqlVariant | Formats an object as SqlVariant type. (Inherited from SqlSmoObject.) |
| GetContextDB | Gets the context database that is associated with this object. (Inherited from SqlSmoObject.) |
| GetDBName | Returns the name of the database on which the instance of Service Broker is implemented. (Inherited from BrokerObjectBase.) |
| GetHashCode | (Inherited from Object.) |
| GetPropValue | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetPropValueOptional | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetServerObject | Gets the server of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetType | (Inherited from 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, 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, 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, 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. (Inherited from SqlSmoObject.) |
| Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.) |
| IsObjectInitialized | Verifies whether the object has been initialized. (Inherited from SqlSmoObject.) |
| IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Inherited from SqlSmoObject.) |
| Refresh | Refreshes the script name. (Inherited from 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, 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, 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, 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. (Inherited from 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. (Inherited from BrokerObjectBase.) |
| SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (Inherited from SqlSmoObject.) |
| ToString | Returns a String that represents the referenced object. (Inherited from SqlSmoObject.) |
| Validate | Validates the state of an object. (Inherited from SmoObjectBase.) |
| Name | Description | |
|---|---|---|
| PropertyChanged | Represents the event that occurs when a property is changed. (Inherited from SqlSmoObject.) |
| PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (Inherited from SqlSmoObject.) |
| Name | Description | |
|---|---|---|
| IAlienObject.Discover | Discovers any dependencies. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject.GetDomainRoot | Returns the root of the domain. (Inherited from SqlSmoObject.) |
| IAlienObject.GetParent | Gets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject.GetPropertyType | Gets the type of the specified property. (Inherited from SqlSmoObject.) |
| IAlienObject.GetPropertyValue | Gets the value of the specified property. (Inherited from SqlSmoObject.) |
| IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Inherited from SqlSmoObject.) |
| IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (Inherited from SqlSmoObject.) |
| IAlienObject.SetPropertyValue | Sets the property value. (Inherited from SqlSmoObject.) |
| ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (Inherited from 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.
| Caution |
|---|
In a future release of SQL Server, BrokerPriority will no longer implement IObjectPermission. |
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.
