Udostępnij przez

ServiceRoute Class

The ServiceRoute object represents a Service Broker route that contains the location information for the service and the database on which it is defined.

Namespace: Microsoft.SqlServer.Management.Smo.Broker
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Deklaracja
<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

[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

/** @attribute EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule) */ 
/** @attribute TypeConverterAttribute(Microsoft.SqlServer.Management.Sdk.Sfc.LocalizableTypeConverter) */ 
/** @attribute PhysicalFacetAttribute() */ 
/** @attribute LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources", true) */ 
public final class ServiceRoute extends BrokerObjectBase implements IObjectPermission, IExtendedProperties, 
    ICreatable, IAlterable, IDroppable

EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule) 
TypeConverterAttribute(Microsoft.SqlServer.Management.Sdk.Sfc.LocalizableTypeConverter) 
PhysicalFacetAttribute 
LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.Broker.BrokerLocalizableResources", true) 
public final class ServiceRoute extends BrokerObjectBase implements IObjectPermission, IExtendedProperties, 
    ICreatable, IAlterable, IDroppable

Remarks

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

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.

  • Last updated on