Clase Service

The Service class represents an instance of the SQL Server service.

Jerarquía de herencia

System.Object
  Microsoft.SqlServer.Management.Smo.SmoObjectBase
    Microsoft.SqlServer.Management.Smo.Wmi.WmiSmoObject
      Microsoft.SqlServer.Management.Smo.Wmi.Service

Espacio de nombres:  Microsoft.SqlServer.Management.Smo.Wmi
Ensamblado:  Microsoft.SqlServer.SqlWmiManagement (en Microsoft.SqlServer.SqlWmiManagement.dll)

Sintaxis

'Declaración
Public NotInheritable Class Service _
    Inherits WmiSmoObject _
    Implements IAlterable
'Uso
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

El tipo Service expone los siguientes miembros.

Propiedades

	Nombre	Descripción
	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.
	IsHadrEnabled	Gets whether the High Availability/Disaster Recovery is enabled.
	Name	Gets or sets the name of the referenced Windows Management Instrumentation (WMI) object. (Se hereda 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. (Se hereda 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. (Se hereda 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. (Se hereda de WmiSmoObject.)
	UserData	Gets or sets user-defined data associated with the referenced object. (Se hereda de SmoObjectBase.)

Arriba

Métodos

	Nombre	Descripción
	Alter	Updates any Service object property changes on an instance of SQL Server.
	ChangeHadrServiceSetting	Changes the HA/DR service settings.
	ChangePassword	Changes the password for the system account under which the SQL Server service is running.
	Equals	(Se hereda de Object.)
	GetHashCode	(Se hereda de Object.)
	GetType	(Se hereda de Object.)
	Initialize	Initializes the referenced object. (Se hereda de WmiSmoObject.)
	IsObjectInitialized	Specifies whether the referenced object is initialized. (Se hereda de WmiSmoObject.)
	Pause	Pauses the SQL Server service.
	Refresh	Refreshes the SQL Server service. (Invalida WmiSmoObject.Refresh().)
	Resume	Resumes the SQL Server service.
	SetName	Sets the name of the referenced object. (Se hereda de WmiSmoObject.)
	SetParentImpl	Sets the parent of the referenced object. (Se hereda 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	(Se hereda de Object.)
	Validate	Validates the state of an object. (Se hereda de SmoObjectBase.)

Arriba

Eventos

	Nombre	Descripción
	ManagementStateChange	An event that occurs when the management state changes.

Arriba

Comentarios

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

Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Ejemplos

Administrar servicios y configuración de red utilizando el proveedor WMI

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Management.Smo.Wmi

Otros recursos

WMI and SQL Server