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.
Espace de noms: Microsoft.SqlServer.Management.Smo.Broker
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntaxe
'Déclaration
Public NotInheritable Class ServiceRoute
Inherits BrokerObjectBase
Implements IObjectPermission, IExtendedProperties, ICreatable, IAlterable, _
IDroppable
public sealed class ServiceRoute : BrokerObjectBase, IObjectPermission, IExtendedProperties, ICreatable,
IAlterable, IDroppable
public ref class ServiceRoute sealed : public BrokerObjectBase, IObjectPermission, IExtendedProperties, ICreatable,
IAlterable, IDroppable
public final class ServiceRoute extends BrokerObjectBase implements IObjectPermission, IExtendedProperties,
ICreatable, IAlterable, IDroppable
public final class ServiceRoute extends BrokerObjectBase implements IObjectPermission, IExtendedProperties,
ICreatable, IAlterable, IDroppable
Notes
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.
Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.
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.
Inheritance Hierarchy
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
Exemple
Readme_ServiceBrokerConfiguration
Sécurité des threads
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.
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Voir aussi
Référence
ServiceRoute Members
Microsoft.SqlServer.Management.Smo.Broker Namespace
Autres ressources
Service Broker Programming
Managing Service Broker
Présentation de Service Broker
CREATE ROUTE (Transact-SQL)