ServiceRoute Miembros
The ServiceRoute object represents a Service Broker route that contains the location information for the service and the database on which it is defined.
El tipo ServiceRoute expone los siguientes miembros.
Constructores
Nombre | Descripción | |
---|---|---|
ServiceRoute() () () () | Initializes a new instance of the ServiceRoute class. | |
ServiceRoute(ServiceBroker, String) | Initializes a new instance of the ServiceRoute class on the specified instance of Service Broker and with the specified name. |
Principio
Métodos
Nombre | Descripción | |
---|---|---|
AddDatabaseContext | (Se hereda de SqlSmoObject). | |
Alter | Updates any ServiceRoute object property changes on the instance of Microsoft SQL Server. | |
AlterImpl | (Se hereda de SqlSmoObject). | |
AlterImplFinish | (Se hereda de SqlSmoObject). | |
AlterImplInit | (Se hereda de SqlSmoObject). | |
AlterImplWorker | (Se hereda de SqlSmoObject). | |
AppendCommaText | (Se hereda de ScriptNameObjectBase). | |
AppendWithCommaText | (Se hereda de ScriptNameObjectBase). | |
AppendWithOption | (Se hereda de ScriptNameObjectBase). | |
BindDefaultImpl | (Se hereda de SqlSmoObject). | |
BindRuleImpl | (Se hereda de SqlSmoObject). | |
CheckCollation | (Se hereda de SqlSmoObject). | |
CheckObjectDirty | (Se hereda de ScriptNameObjectBase). | |
CheckObjectState() () () () | Validates the state of the referenced object. (Se hereda de SqlSmoObject). | |
CheckObjectState(Boolean) | Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (Se hereda de SqlSmoObject). | |
CheckObjectStateImpl | (Se hereda de SqlSmoObject). | |
CheckTextCorectness | (Se hereda de ScriptNameObjectBase). | |
CheckTextModeSupport | (Se hereda de ScriptNameObjectBase). | |
CheckVersion100 | (Se hereda de SqlSmoObject). | |
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Se hereda de SqlSmoObject). | |
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Se hereda de SqlSmoObject). | |
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Se hereda de SqlSmoObject). | |
CheckVersionBelow90 | (Se hereda de SqlSmoObject). | |
CleanObject | Cleans the referenced object. (Se hereda de ScriptNameObjectBase). | |
Create | Creates a service route on the instance of Microsoft SQL Server as defined by the ServiceRoute object. | |
CreateImpl | (Se hereda de SqlSmoObject). | |
CreateImplFinish | (Se hereda de SqlSmoObject). | |
CreateImplInit | (Se hereda de SqlSmoObject). | |
Deny(ObjectPermissionSet, String) | Denies access to the specified permission for the specified grantee on the service route. | |
Deny(ObjectPermissionSet, array<String> [] () [] []) | Denies access to the specified permission for the specified grantees on the service route. | |
Deny(ObjectPermissionSet, String, Boolean) | Denies access to the specified permission for the specified grantee and other users who the grantee granted access on the service route. | |
Deny(ObjectPermissionSet, array<String> [] () [] [], Boolean) | Denies access to the specified permission for the specified grantees on the service route. | |
Discover | (Se hereda de SqlSmoObject). | |
Drop | Removes the service route. | |
DropImpl | (Se hereda de SqlSmoObject). | |
DropImplWorker | (Se hereda de SqlSmoObject). | |
EnumObjectPermissions() () () () | Enumerates a list of object permissions for the service route. | |
EnumObjectPermissions(String) | Enumerates a list of object permissions for a specified grantee on the service route. | |
EnumObjectPermissions(ObjectPermissionSet) | Enumerates a list of object permissions for a specified permission on the service route. | |
EnumObjectPermissions(String, ObjectPermissionSet) | Enumerates a list of object permissions for a specified grantee and a specified permission on the service route. | |
EnumScriptImpl | (Se hereda de SqlSmoObject). | |
EnumScriptImplWorker | (Se hereda de SqlSmoObject). | |
Equals | (Se hereda de Object). | |
Finalize | (Se hereda de Object). | |
ForceTextModeOnTextBody | Enforces text mode on the text body. (Se hereda de ScriptNameObjectBase). | |
FormatSqlVariant | (Se hereda de SqlSmoObject). | |
GenerateDataSpaceFileStreamScript | (Se hereda de SqlSmoObject). | |
GenerateDataSpaceScript | (Se hereda de SqlSmoObject). | |
GetBindDefaultScript | (Se hereda de SqlSmoObject). | |
GetBindRuleScript | (Se hereda de SqlSmoObject). | |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Se hereda de SqlSmoObject). | |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Se hereda de SqlSmoObject). | |
GetBraketNameForText | (Se hereda de ScriptNameObjectBase). | |
GetDateTimeParameter | (Se hereda de SqlSmoObject). | |
GetDateTimeParameterAsInt | (Se hereda de SqlSmoObject). | |
GetDBName | Returns the name of the database on which the instance of Service Broker is implemented. (Se hereda de BrokerObjectBase). | |
GetEnumParameter | (Se hereda de SqlSmoObject). | |
GetFragOptionString | (Se hereda de SqlSmoObject). | |
GetGuidParameter | (Se hereda de SqlSmoObject). | |
GetHashCode | (Se hereda de Object). | |
GetIsTextDirty | Determines whether the text value is consistent with stored value. (Se hereda de ScriptNameObjectBase). | |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Se hereda de SqlSmoObject). | |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Se hereda de SqlSmoObject). | |
GetPropValue | (Se hereda de SqlSmoObject). | |
GetPropValueOptional | (Se hereda de SqlSmoObject). | |
GetPropValueOptionalAllowNull | (Se hereda de SqlSmoObject). | |
GetRealValue | (Se hereda de SqlSmoObject). | |
GetScriptIncludeExists | (Se hereda de ScriptNameObjectBase). | |
GetScriptingOptionsForCreate | (Se hereda de SqlSmoObject). | |
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Se hereda de SqlSmoObject). | |
GetServerObject | (Se hereda de SqlSmoObject). | |
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Se hereda de SqlSmoObject). | |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Se hereda de SqlSmoObject). | |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Se hereda de SqlSmoObject). | |
GetTextBody() () () () | Returns the text body. (Se hereda de ScriptNameObjectBase). | |
GetTextBody(Boolean) | Returns the text body. (Se hereda de ScriptNameObjectBase). | |
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] []) | Gets the text for scripting. (Se hereda de ScriptNameObjectBase). | |
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [], Boolean) | (Se hereda de ScriptNameObjectBase). | |
GetTextHeader | Returns the text header. (Se hereda de ScriptNameObjectBase). | |
GetTextMode | Determines whether the script name is using text mode. (Se hereda de ScriptNameObjectBase). | |
GetTextProperty(String) | (Se hereda de ScriptNameObjectBase). | |
GetTextProperty(String, ScriptingOptions) | (Se hereda de ScriptNameObjectBase). | |
GetTimeSpanParameterAsInt | (Se hereda de SqlSmoObject). | |
GetType | (Se hereda de Object). | |
GetUrnRecursive(StringBuilder) | (Se hereda de SqlSmoObject). | |
GetUrnRecursive(StringBuilder, UrnIdOption) | (Se hereda de SqlSmoObject). | |
Grant(ObjectPermissionSet, String) | Grants access to the specified permission for the specified grantee on the service route. | |
Grant(ObjectPermissionSet, array<String> [] () [] []) | Grants access to the specified permission for the specified grantees on the service route. | |
Grant(ObjectPermissionSet, String, Boolean) | Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the service route. | |
Grant(ObjectPermissionSet, array<String> [] () [] [], Boolean) | Grants access to the specified permission and the ability to grant access to other users for the specified grantees on the service route. | |
Grant(ObjectPermissionSet, String, Boolean, String) | Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the service route. | |
Grant(ObjectPermissionSet, array<String> [] () [] [], Boolean, String) | Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the service route under an assumed role. | |
ImplInitialize | (Se hereda de SqlSmoObject). | |
Initialize() () () () | Initializes the object and forces the properties be loaded. (Se hereda de SqlSmoObject). | |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Se hereda de SqlSmoObject). | |
IsObjectDirty | Determines whether the referenced object is consistent with the stored object. (Se hereda de ScriptNameObjectBase). | |
IsObjectInitialized | Verifies whether the object has been initialized. (Se hereda de SqlSmoObject). | |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Se hereda de SqlSmoObject). | |
IsVersion80SP3 | (Se hereda de SqlSmoObject). | |
MarkDropped | (Se hereda de SqlSmoObject). | |
MarkForDropImpl | (Se hereda de SqlSmoObject). | |
MemberwiseClone | (Se hereda de Object). | |
PostAlter | (Se hereda de SqlSmoObject). | |
PostCreate | (Se hereda de SqlSmoObject). | |
PostDrop | (Se hereda de SqlSmoObject). | |
Refresh | Refreshes the script name. (Se hereda de ScriptNameObjectBase). | |
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Se hereda de NamedSmoObject). | |
RenameImplWorker | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Se hereda de NamedSmoObject). | |
Revoke(ObjectPermissionSet, String) | Revokes previously granted permissions from a grantee on the service route. | |
Revoke(ObjectPermissionSet, array<String> [] () [] []) | Revokes previously granted permissions from a list of grantees on the service route. | |
Revoke(ObjectPermissionSet, String, Boolean, Boolean) | Revokes previously granted permissions from a grantee on the service route 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, array<String> [] () [] [], Boolean, Boolean) | Revokes previously granted permissions from a grantees on the service route and any other users to whom the grantees have granted access. The grantees are also given the ability to revoke other users' access. | |
Revoke(ObjectPermissionSet, String, Boolean, Boolean, String) | Revokes previously granted permissions from a grantee on the service route and any other users to whom the grantee has granted access. The grantee is also given the ability to revoke other users' access under an assumed role. | |
Revoke(ObjectPermissionSet, array<String> [] () [] [], Boolean, Boolean, String) | Revokes previously granted permissions from grantees on the service route and any other users to whom the grantees have granted access. The grantees are also given the ability to revoke other users' access under an assumed role. | |
Script() () () () | Generates a Transact-SQL script that can be used to re-create the Service Broker object. (Se hereda de 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. (Se hereda de BrokerObjectBase). | |
ScriptAlter | (Se hereda de SqlSmoObject). | |
ScriptAnsiQI | (Se hereda de ScriptNameObjectBase). | |
ScriptChangeOwner | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Se hereda de NamedSmoObject). | |
ScriptCreate | (Se hereda de SqlSmoObject). | |
ScriptDdl | (Se hereda de SqlSmoObject). | |
ScriptDrop | (Se hereda de SqlSmoObject). | |
ScriptImpl() () () () | (Se hereda de SqlSmoObject). | |
ScriptImpl(ScriptingOptions) | (Se hereda de SqlSmoObject). | |
ScriptImplWorker | (Se hereda de SqlSmoObject). | |
ScriptInformativeHeaders | (Se hereda de ScriptNameObjectBase). | |
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Se hereda de NamedSmoObject). | |
SetCollectionTextMode | Sets the collection text mode. (Se hereda de ScriptNameObjectBase). | |
SetParentImpl | (Se hereda de SqlSmoObject). | |
SetTextBody | Specifies the text body. (Se hereda de ScriptNameObjectBase). | |
SetTextHeader | Specifies the text header. (Se hereda de ScriptNameObjectBase). | |
SetTextMode | Specifies the text mode. (Se hereda de ScriptNameObjectBase). | |
SwitchTextMode | Switches the text mode. (Se hereda de ScriptNameObjectBase). | |
ThrowIfTextIsDirtyForAlter | (Se hereda de ScriptNameObjectBase). | |
ToString | Returns a String that represents the referenced object. (Se hereda de SqlSmoObject). | |
TouchImpl | (Se hereda de SqlSmoObject). | |
UnbindDefaultImpl | (Se hereda de SqlSmoObject). | |
UnbindRuleImpl | (Se hereda de SqlSmoObject). | |
Validate | (Se hereda de SmoObjectBase). |
Principio
Propiedades
Nombre | Descripción | |
---|---|---|
Address | Gets or sets the connection string for the remote Service Broker instance addressed by the route. | |
BrokerInstance | Gets or sets the Service Broker instance that hosts the remote service. | |
Events | Gets the events associated with the service route. | |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Se hereda de SqlSmoObject). | |
ExpirationDate | Gets or sets the date and time when the service route expires. | |
ExtendedProperties | Gets the extended properties of the ServiceRoute object. | |
ID | Gets the ID value that uniquely identifies the service route. | |
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Se hereda de SqlSmoObject). | |
MirrorAddress | Gets or sets the connection string of the remote mirrored Service Broker instance addressed by this route. | |
Name | Gets or sets the name of the object. (Se hereda de NamedSmoObject). | |
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Se hereda de SqlSmoObject). | |
Owner | Gets or sets the owner of the service route. | |
Parent | Gets or sets the ServiceBroker object that is the parent of the ServiceRoute object. | |
Properties | Gets a collection of Property objects that represent the object properties. (Se hereda de SqlSmoObject). | |
RemoteService | Gets or sets the remote service addressed by the service route. | |
ScalarResult | Gets the scalar result for the referenced object. (Se hereda de SqlSmoObject). | |
State | Gets the state of the referenced object. (Se hereda de SmoObjectBase). | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Se hereda de SqlSmoObject). | |
UserData | Gets or sets user-defined data associated with the referenced object. (Se hereda de SmoObjectBase). |
Principio
Eventos
Nombre | Descripción | |
---|---|---|
PropertyChanged | (Se hereda de SqlSmoObject). | |
PropertyMetadataChanged | (Se hereda de SqlSmoObject). |
Principio
Implementaciones de interfaces explícitas
Nombre | Descripción | |
---|---|---|
IAlienObjectDiscover | (Se hereda de SqlSmoObject). | |
IAlienObjectGetParent | (Se hereda de SqlSmoObject). | |
IAlienObjectGetProperty | (Se hereda de SqlSmoObject). | |
ISfcPropertyProviderGetPropertySet | (Se hereda de SqlSmoObject). | |
IAlienObjectGetUrn | (Se hereda de SqlSmoObject). | |
IAlienObjectResolve | (Se hereda de SqlSmoObject). | |
IAlienObjectSetProperty | (Se hereda de SqlSmoObject). |
Principio
Vea también