Service-Klasse
The Service class represents an instance of the SQL Server service.
Vererbungshierarchie
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
Microsoft.SqlServer.Management.Smo.Wmi. . :: . .WmiSmoObject
Microsoft.SqlServer.Management.Smo.Wmi..::..Service
Namespace: Microsoft.SqlServer.Management.Smo.Wmi
Assembly: Microsoft.SqlServer.SqlWmiManagement (in Microsoft.SqlServer.SqlWmiManagement.dll)
Syntax
'Declaration
Public NotInheritable Class Service _
Inherits WmiSmoObject _
Implements IAlterable
'Usage
Dim instance As Service
public sealed class Service : WmiSmoObject,
IAlterable
public ref class Service sealed : public WmiSmoObject,
IAlterable
[<SealedAttribute>]
type Service =
class
inherit WmiSmoObject
interface IAlterable
end
public final class Service extends WmiSmoObject implements IAlterable
Der Service-Typ macht folgende Elemente verfügbar.
Eigenschaften
Name | Beschreibung | |
---|---|---|
AcceptsPause | Gets the Boolean property value that specifies whether the SQL Server service can be paused. | |
AcceptsStop | Gets the Boolean property value that specifies whether the SQL Server service can be stopped. | |
AdvancedProperties | Represents a collection of Property objects. Each Property object represents an advanced property defined on the SQL Server service. | |
Dependencies | Returns a list of services that are dependent on the referenced SQL Server service. | |
Description | Gets a textual description of the SQL Server service. | |
DisplayName | Gets the display name of the SQL Server service. | |
ErrorControl | Gets the severity of the error if the SQL Server service fails to start during startup. | |
ExitCode | Gets the Win32 error code that defines problems encountered when starting and stopping the SQL Server service. | |
Name | Gets or sets the name of the referenced Windows Management Instrumentation (WMI) object. (Geerbt von WmiSmoObject.) | |
Parent | Gets the ManagedComputer object that is the parent of the Service object. | |
PathName | Gets the path and file name of the binary file that implements the SQL Server service. | |
ProcessId | Gets the process ID that uniquely identifies the SQL Server service. | |
Properties | Represents a collection of Property objects. Each Property object represents a property defined on the Windows Management Instrumentation (WMI) object. (Geerbt von WmiSmoObject.) | |
ServiceAccount | Gets the system account under which the SQL Server service is running. | |
ServiceState | Gets the state of the SQL Server service, such as running, stopped, or paused. | |
StartMode | Gets or sets the method by which the SQL Server service is started. | |
StartupParameters | Gets or sets any startup parameters for the SQL Server service. | |
State | Gets the state of the referenced object. (Geerbt von SmoObjectBase.) | |
Type | Gets the type of service, such as Microsoft Search service, SQL Server Agent service, or SQL Server service. | |
Urn | Gets the Uniform Resource Name (URN) address that represents the Windows Management Instrumentation (WMI) object. (Geerbt von WmiSmoObject.) | |
UserData | Gets or sets user-defined data associated with the referenced object. (Geerbt von SmoObjectBase.) |
Zum Anfang
Methoden
Name | Beschreibung | |
---|---|---|
Alter | Updates any Service object property changes on an instance of SQL Server. | |
AlterProtocolProperties | Updates any protocol object property changes on the Windows Management Instrumentation (WMI) installation. (Geerbt von WmiSmoObject.) | |
ChangePassword | Changes the password for the system account under which the SQL Server service is running. | |
CheckObjectState | Checks the state of the referenced object. (Geerbt von WmiSmoObject.) | |
CreateProtocolPropertyCollection | Creates a set of protocol attributes for the referenced object. (Geerbt von WmiSmoObject.) | |
Equals | (Geerbt von Object.) | |
Finalize | (Geerbt von Object.) | |
GetHashCode | (Geerbt von Object.) | |
GetPropertyManagementObject | Gets the management object for the specified protocol property. (Geerbt von WmiSmoObject.) | |
GetPropertyObject | Gets the property from the specified collection with the specified position and value. (Geerbt von WmiSmoObject.) | |
GetProtocolPropertyCollection | Returns the protocol property collection for the referenced object. (Geerbt von WmiSmoObject.) | |
GetType | (Geerbt von Object.) | |
ImplInitialize | Initializes the fields of the WmiSmoObjectobject. (Geerbt von WmiSmoObject.) | |
Initialize | Initializes the referenced object. (Geerbt von WmiSmoObject.) | |
InvokeMgmtMethod(ManagementObject, String, array<Object> [] () [] []) | Invokes the management method for the referenced object with the specified management object, method name, and parameters. (Geerbt von WmiSmoObject.) | |
InvokeMgmtMethod(ManagementObject, ManagementOperationObserver, String, array<Object> [] () [] []) | Invokes the management method for the referenced object with the specified management object, observer, method name, and parameters. (Geerbt von WmiSmoObject.) | |
IsObjectInitialized | Specifies whether the referenced object is initialized. (Geerbt von WmiSmoObject.) | |
MemberwiseClone | (Geerbt von Object.) | |
Pause | Pauses the SQL Server service. | |
Refresh | Refreshes the SQL Server service. (Überschreibt WmiSmoObject. . :: . .Refresh() () () ().) | |
Resume | Resumes the SQL Server service. | |
SetName | Sets the name of the referenced object. (Geerbt von WmiSmoObject.) | |
SetParentImpl | Sets the parent of the referenced object. (Geerbt von WmiSmoObject.) | |
SetServiceAccount | Sets the account under which the SQL Server service runs. | |
Start | Starts the SQL Server service. | |
Stop | Stops the SQL Server service. | |
ToString | (Geerbt von Object.) | |
UpdateObjectState | Updates the object state. (Geerbt von WmiSmoObject.) | |
Validate | Validates the state of an object. (Geerbt von SmoObjectBase.) |
Zum Anfang
Ereignisse
Name | Beschreibung | |
---|---|---|
ManagementStateChange | An event that occurs when the management state changes. |
Zum Anfang
Hinweise
The Service object is used to programmatically manage the SQL Server service. With the Service object you can:
Connect to the service.
Modify the account and password used to connect to the service.
Start, stop, pause, and resume the service.
Check the properties of the service.
Thread Safety
Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Für Instanzelemente kann nicht sichergestellt werden, dass sie für Threads sicher sind.
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.
Siehe auch