Service Members

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

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

Public Properties

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

В начало

Public Methods

(see also Protected Methods )

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

В начало

Protected Methods

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

В начало

Public Events

  Имя Description
ms220784.pubevent(ru-ru,SQL.90).gif ManagementStateChange An event that occurs when the management state changes.

В начало

См. также

Справочник

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

Другие ресурсы

Managing Services and Network Settings by Using WMI Provider
WMI and SQL Server
Подключение к компоненту Database Engine SQL Server