Service 类

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

继承层次结构

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

命名空间:  Microsoft.SqlServer.Management.Smo.Wmi
程序集:  Microsoft.SqlServer.SqlWmiManagement(在 Microsoft.SqlServer.SqlWmiManagement.dll 中)

语法

声明
Public NotInheritable Class Service _
    Inherits WmiSmoObject _
    Implements IAlterable
用法
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

Service 类型公开以下成员。

属性

  名称 说明
公共属性 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. (从 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. (从 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. (从 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. (从 WmiSmoObject 继承。)
公共属性 UserData Gets or sets user-defined data associated with the referenced object. (从 SmoObjectBase 继承。)

页首

方法

  名称 说明
公共方法 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 (从 Object 继承。)
公共方法 GetHashCode (从 Object 继承。)
公共方法 GetType (从 Object 继承。)
公共方法 Initialize Initializes the referenced object. (从 WmiSmoObject 继承。)
受保护方法 IsObjectInitialized Specifies whether the referenced object is initialized. (从 WmiSmoObject 继承。)
公共方法 Pause Pauses the SQL Server service.
公共方法 Refresh Refreshes the SQL Server service. (覆盖 WmiSmoObject.Refresh()。)
公共方法 Resume Resumes the SQL Server service.
受保护方法 SetName Sets the name of the referenced object. (从 WmiSmoObject 继承。)
受保护方法 SetParentImpl Sets the parent of the referenced object. (从 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 (从 Object 继承。)
公共方法 Validate Validates the state of an object. (从 SmoObjectBase 继承。)

页首

事件

  名称 说明
公共事件 ManagementStateChange An event that occurs when the management state changes.

页首

注释

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

此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。

示例

使用 WMI 提供程序管理服务和网络设置

线程安全

此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Management.Smo.Wmi 命名空间

其他资源

WMI and SQL Server