• Article

Service Members

Include Protected Members
Include Inherited Members

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

The Service type exposes the following members.

Methods

  Name Description
Public method Alter() Updates any Service object property changes on an instance of SQL Server.
Protected method AlterProtocolProperties(ProtocolPropertyCollection) Updates any protocol object property changes on the Windows Management Instrumentation (WMI) installation. (Inherited from WmiSmoObject.)
Public method ChangePassword(String, String) Changes the password for the system account under which the SQL Server service is running.
Protected method CheckObjectState() Checks the state of the referenced object. (Inherited from WmiSmoObject.)
Protected method CreateProtocolPropertyCollection() Creates a set of protocol attributes for the referenced object. (Inherited from WmiSmoObject.)
Public method Equals(Object) (Inherited from Object.)
Protected method Finalize() (Inherited from Object.)
Public method GetHashCode() (Inherited from Object.)
Protected method GetPropertyManagementObject(ProtocolProperty) Gets the management object for the specified protocol property. (Inherited from WmiSmoObject.)
Protected method GetPropertyObject(PropertyCollection, DataRow, Object) Gets the property from the specified collection with the specified position and value. (Inherited from WmiSmoObject.)
Protected method GetProtocolPropertyCollection() Returns the protocol property collection for the referenced object. (Inherited from WmiSmoObject.)
Public method GetType() (Inherited from Object.)
Protected method ImplInitialize(array<String[], array<OrderBy[]) (Inherited from WmiSmoObject.)
Public method Initialize() Initializes the referenced object. (Inherited from WmiSmoObject.)
Protected method InvokeMgmtMethod(ManagementObject, String, array<Object[]) Invokes the management method for the referenced object with the specified management object, method name, and parameters. (Inherited from WmiSmoObject.)
Protected method InvokeMgmtMethod(ManagementObject, ManagementOperationObserver, String, array<Object[]) Invokes the management method for the referenced object with the specified management object, observer, method name, and parameters. (Inherited from WmiSmoObject.)
Protected method IsObjectInitialized() Specifies whether the referenced object is initialized. (Inherited from WmiSmoObject.)
Protected method MemberwiseClone() (Inherited from Object.)
Public method Pause() Pauses the SQL Server service.
Public method Refresh() Refreshes the SQL Server service. (Overrides WmiSmoObject.Refresh().)
Public method Resume() Resumes the SQL Server service.
Protected method SetName(String) Sets the name of the referenced object. (Inherited from WmiSmoObject.)
Protected method SetParentImpl(WmiSmoObject) Sets the parent of the referenced object. (Inherited from WmiSmoObject.)
Public method SetServiceAccount(String, String) Sets the account under which the SQL Server service runs.
Public method Start() Starts the SQL Server service.
Public method Stop() Stops the SQL Server service.
Public method ToString() (Inherited from Object.)
Protected method UpdateObjectState() Updates the object state. (Inherited from WmiSmoObject.)
Public method Validate(String, array<Object[]) (Inherited from SmoObjectBase.)

Top

Properties

  Name Description
Public property AcceptsPause Gets the Boolean property value that specifies whether the SQL Server service can be paused.
Public property AcceptsStop Gets the Boolean property value that specifies whether the SQL Server service can be stopped.
Public property AdvancedProperties Represents a collection of Property objects. Each Property object represents an advanced property defined on the SQL Server service.
Public property Dependencies Returns a list of services that are dependent on the referenced SQL Server service.
Public property Description Gets a textual description of the SQL Server service.
Public property DisplayName Gets the display name of the SQL Server service.
Public property ErrorControl Gets the severity of the error if the SQL Server service fails to start during startup.
Public property ExitCode Gets the Win32 error code that defines problems encountered when starting and stopping the SQL Server service.
Public property Name Gets or sets the name of the referenced Windows Management Instrumentation (WMI) object. (Inherited from WmiSmoObject.)
Public property Parent Gets the ManagedComputer object that is the parent of the Service object.
Public property PathName Gets the path and file name of the binary file that implements the SQL Server service.
Public property ProcessId Gets the process ID that uniquely identifies the SQL Server service.
Public property Properties Represents a collection of Property objects. Each Property object represents a property defined on the Windows Management Instrumentation (WMI) object. (Inherited from WmiSmoObject.)
Public property ServiceAccount Gets the system account under which the SQL Server service is running.
Public property ServiceState Gets the state of the SQL Server service, such as running, stopped, or paused.
Public property StartMode Gets or sets the method by which the SQL Server service is started.
Public property StartupParameters Gets or sets any startup parameters for the SQL Server service.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Type Gets the type of service, such as Microsoft Search service, SQL Server Agent service, or SQL Server service.
Public property Urn Gets the Uniform Resource Name (URN) address that represents the Windows Management Instrumentation (WMI) object. (Inherited from WmiSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)

Top

Events

  Name Description
Public event ManagementStateChange An event that occurs when the management state changes.

Top