Condividi tramite

  • Articolo

Classe ServiceRoute

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

Spazio dei nomi:  Microsoft.SqlServer.Management.Smo.Broker
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<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
'Utilizzo
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

Osservazioni

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

Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.

Thread Safety

Tutti i membri pubblici static (Shared in Visual Basic) di questo tipo sono thread safe. I membri di istanza non hanno garanzia di essere thread safe.