Classe Service
The Service class represents an instance of the SQL Server service.
Hiérarchie d'héritage
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
Microsoft.SqlServer.Management.Smo.Wmi. . :: . .WmiSmoObject
Microsoft.SqlServer.Management.Smo.Wmi..::..Service
Espace de noms : Microsoft.SqlServer.Management.Smo.Wmi
Assembly : Microsoft.SqlServer.SqlWmiManagement (en Microsoft.SqlServer.SqlWmiManagement.dll)
Syntaxe
'Déclaration
Public NotInheritable Class Service _
Inherits WmiSmoObject _
Implements IAlterable
'Utilisation
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
Le type Service expose les membres suivants.
Propriétés
Nom | Description | |
---|---|---|
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. (hérité de 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. (hérité de 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. (hérité de 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. (hérité de WmiSmoObject.) | |
UserData | Gets or sets user-defined data associated with the referenced object. (hérité de SmoObjectBase.) |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
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. (hérité de 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. (hérité de WmiSmoObject.) | |
CreateProtocolPropertyCollection | Creates a set of protocol attributes for the referenced object. (hérité de WmiSmoObject.) | |
Equals | (hérité de Object.) | |
Finalize | (hérité de Object.) | |
GetHashCode | (hérité de Object.) | |
GetPropertyManagementObject | Gets the management object for the specified protocol property. (hérité de WmiSmoObject.) | |
GetPropertyObject | Gets the property from the specified collection with the specified position and value. (hérité de WmiSmoObject.) | |
GetProtocolPropertyCollection | Returns the protocol property collection for the referenced object. (hérité de WmiSmoObject.) | |
GetType | (hérité de Object.) | |
ImplInitialize | Initializes the fields of the WmiSmoObjectobject. (hérité de WmiSmoObject.) | |
Initialize | Initializes the referenced object. (hérité de WmiSmoObject.) | |
InvokeMgmtMethod(ManagementObject, String, array<Object> [] () [] []) | Invokes the management method for the referenced object with the specified management object, method name, and parameters. (hérité de 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. (hérité de WmiSmoObject.) | |
IsObjectInitialized | Specifies whether the referenced object is initialized. (hérité de WmiSmoObject.) | |
MemberwiseClone | (hérité de Object.) | |
Pause | Pauses the SQL Server service. | |
Refresh | Refreshes the SQL Server service. (remplace WmiSmoObject. . :: . .Refresh() () () ().) | |
Resume | Resumes the SQL Server service. | |
SetName | Sets the name of the referenced object. (hérité de WmiSmoObject.) | |
SetParentImpl | Sets the parent of the referenced object. (hérité de 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 | (hérité de Object.) | |
UpdateObjectState | Updates the object state. (hérité de WmiSmoObject.) | |
Validate | Validates the state of an object. (hérité de SmoObjectBase.) |
Haut de la page
Événements
Nom | Description | |
---|---|---|
ManagementStateChange | An event that occurs when the management state changes. |
Haut de la page
Notes
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
Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Voir aussi