ServiceRoute Clase
The ServiceRoute object represents a Service Broker route that contains the location information for the service and the database on which it is defined.
Espacio de nombres: Microsoft.SqlServer.Management.Smo.Broker
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<PhysicalFacetAttribute> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources", _
True)> _
Public NotInheritable Class ServiceRoute _
Inherits BrokerObjectBase _
Implements IObjectPermission, IExtendedProperties, ICreatable, IAlterable, _
IDroppable
'Uso
Dim instance As ServiceRoute
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[PhysicalFacetAttribute]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources",
true)]
public sealed class ServiceRoute : BrokerObjectBase,
IObjectPermission, IExtendedProperties, ICreatable, IAlterable, IDroppable
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[PhysicalFacetAttribute]
[LocalizedPropertyResourcesAttribute(L"Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources",
true)]
public ref class ServiceRoute sealed : public BrokerObjectBase,
IObjectPermission, IExtendedProperties, ICreatable, IAlterable, IDroppable
[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<PhysicalFacetAttribute>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources",
true)>]
type ServiceRoute =
class
inherit BrokerObjectBase
interface IObjectPermission
interface IExtendedProperties
interface ICreatable
interface IAlterable
interface IDroppable
end
public final class ServiceRoute extends BrokerObjectBase implements IObjectPermission, IExtendedProperties, ICreatable, IAlterable, IDroppable
Notas
A route is required for message delivery. By default, each database contains a route that specifies the location as the current instance of Microsoft SQL Server.
To get ServiceRoute object properties, users can be a member of the public fixed server role.
To set ServiceRoute 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 route, 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 route, 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 grant, deny, or revoke permissions on the message type to other users, users must have CONTROL permission on the service route.
Thread Safety
Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.
Jerarquía de herencia
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..::..ServiceRoute
Seguridad para subprocesos
Todos los miembros públicos static (Shared en Visual Basic) de este tipo son seguros para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.