TargetServer Miembros
The TargetServer object represents a target server defined for multiserver administration on SQL Server Agent.
El tipo TargetServer expone los siguientes miembros.
Métodos
Nombre | Descripción | |
---|---|---|
AddDatabaseContext | (Se hereda de SqlSmoObject). | |
AlterImpl | (Se hereda de SqlSmoObject). | |
AlterImplFinish | (Se hereda de SqlSmoObject). | |
AlterImplInit | (Se hereda de SqlSmoObject). | |
AlterImplWorker | (Se hereda de SqlSmoObject). | |
BindDefaultImpl | (Se hereda de SqlSmoObject). | |
BindRuleImpl | (Se hereda de SqlSmoObject). | |
CheckCollation | (Se hereda de SqlSmoObject). | |
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). | |
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 | (Se hereda de SqlSmoObject). | |
CreateImpl | (Se hereda de SqlSmoObject). | |
CreateImplFinish | (Se hereda de SqlSmoObject). | |
CreateImplInit | (Se hereda de SqlSmoObject). | |
Discover | (Se hereda de SqlSmoObject). | |
DropImpl | (Se hereda de SqlSmoObject). | |
DropImplWorker | (Se hereda de SqlSmoObject). | |
EnumScriptImpl | (Se hereda de SqlSmoObject). | |
EnumScriptImplWorker | (Se hereda de SqlSmoObject). | |
Equals | (Se hereda de Object). | |
Finalize | (Se hereda de Object). | |
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). | |
GetDateTimeParameter | (Se hereda de SqlSmoObject). | |
GetDateTimeParameterAsInt | (Se hereda de SqlSmoObject). | |
GetDBName | Gets the database name that is associated with the object. (Se hereda de AgentObjectBase). | |
GetEnumParameter | (Se hereda de SqlSmoObject). | |
GetFragOptionString | (Se hereda de SqlSmoObject). | |
GetGuidParameter | (Se hereda de SqlSmoObject). | |
GetHashCode | (Se hereda de Object). | |
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). | |
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). | |
GetTimeSpanParameterAsInt | (Se hereda de SqlSmoObject). | |
GetType | (Se hereda de Object). | |
GetUrnRecursive(StringBuilder) | (Se hereda de SqlSmoObject). | |
GetUrnRecursive(StringBuilder, UrnIdOption) | (Se hereda de SqlSmoObject). | |
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 | Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (Se hereda de SqlSmoObject). | |
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 object and retrieves properties when the object is next accessed. (Se hereda de SqlSmoObject). | |
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). | |
ScriptAlter | (Se hereda de SqlSmoObject). | |
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). | |
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Se hereda de NamedSmoObject). | |
SetParentImpl | (Se hereda de SqlSmoObject). | |
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 | |
---|---|---|
EnlistDate | Gets the date and time at which an instance of Microsoft SQL Server was enlisted as a member of a multiserver administration group. | |
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). | |
ID | Gets the ID value for the instance of Microsoft SQL Server that is the target server. | |
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). | |
LastPollDate | Gets the most recent date and time at which the referenced target server successfully connected to its master server. | |
LocalTime | Gets the current date and time for the referenced target server. | |
Location | Gets or sets the physical location of the referenced target server. | |
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). | |
Parent | Gets the JobServer object that is the parent of the TargetServer object. | |
PendingInstructions | Gets the number of SQL Server Agent maintenance tasks waiting to be downloaded by the target server from the master server. | |
PollingInterval | Gets the length of time in seconds that the target server waits between attempts to connect to the master server to download pending instructions. | |
Properties | Gets a collection of Property objects that represent the object properties. (Se hereda de SqlSmoObject). | |
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). | |
Status | Gets information about the current component execution status or integrity status of the referenced target server. | |
TimeZoneAdjustment | Gets the difference, in minutes, between the local time midnight on the target server and midnight Coordinated Universal Time (Greenwich Mean Time). | |
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