Share via

Service Members

  • Article

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

The following tables list the members exposed by the Service type.

Public Properties

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

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220784.pubmethod(en-US,SQL.90).gif Alter Updates any Service object property changes on an instance of SQL Server.
ms220784.pubmethod(en-US,SQL.90).gif ChangePassword Changes the password for the system account under which the SQL Server service is running.
ms220784.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220784.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms220784.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220784.pubmethod(en-US,SQL.90).gif Initialize  Initializes the referenced object. (inherited from WmiSmoObject)
ms220784.pubmethod(en-US,SQL.90).gif Pause Pauses the SQL Server service.
ms220784.pubmethod(en-US,SQL.90).gifms220784.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220784.pubmethod(en-US,SQL.90).gif Refresh Overridden. Refreshes the SQL Server service.
ms220784.pubmethod(en-US,SQL.90).gif Resume Resumes the SQL Server service.
ms220784.pubmethod(en-US,SQL.90).gif SetServiceAccount Sets the account under which the SQL Server service runs.
ms220784.pubmethod(en-US,SQL.90).gif Start Starts the SQL Server service.
ms220784.pubmethod(en-US,SQL.90).gif Stop Stops the SQL Server service.
ms220784.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms220784.protmethod(en-US,SQL.90).gif AlterProtocolProperties  (inherited from WmiSmoObject )
ms220784.protmethod(en-US,SQL.90).gif CheckObjectState  Checks the state of the referenced object. (inherited from WmiSmoObject)
ms220784.protmethod(en-US,SQL.90).gif CreateProtocolPropertyCollection  Creates a set of protocol attributes for the referenced object. (inherited from WmiSmoObject)
ms220784.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms220784.protmethod(en-US,SQL.90).gif GetPropertyManagementObject  (inherited from WmiSmoObject )
ms220784.protmethod(en-US,SQL.90).gif GetPropertyObject  (inherited from WmiSmoObject )
ms220784.protmethod(en-US,SQL.90).gif GetProtocolPropertyCollection  Returns the protocol property collection for the referenced object. (inherited from WmiSmoObject)
ms220784.protmethod(en-US,SQL.90).gif ImplInitialize  (inherited from WmiSmoObject )
ms220784.protmethod(en-US,SQL.90).gif InvokeMgmtMethod  Overloaded. (inherited from WmiSmoObject )
ms220784.protmethod(en-US,SQL.90).gif IsObjectInitialized  Specifies whether the referenced object is initialized. (inherited from WmiSmoObject)
ms220784.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms220784.protmethod(en-US,SQL.90).gif SetName  (inherited from WmiSmoObject )
ms220784.protmethod(en-US,SQL.90).gif SetParentImpl  (inherited from WmiSmoObject )
ms220784.protmethod(en-US,SQL.90).gifms220784.static(en-US,SQL.90).gif Trace  (inherited from WmiSmoObject )
ms220784.protmethod(en-US,SQL.90).gif UpdateObjectState  Updates the object state. (inherited from WmiSmoObject)

Top

Public Events

  Name Description
ms220784.pubevent(en-US,SQL.90).gif ManagementStateChange An event that occurs when the management state changes.

Top

See Also

Reference

Service Class
Microsoft.SqlServer.Management.Smo.Wmi Namespace

Other Resources

Managing Services and Network Settings by Using WMI Provider
WMI and SQL Server
Connecting to the SQL Server Database Engine