共用方式為


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.
公用屬性 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.
受保護的方法 AlterProtocolProperties Updates any protocol object property changes on the Windows Management Instrumentation (WMI) installation. (繼承自 WmiSmoObject。)
公用方法 ChangePassword Changes the password for the system account under which the SQL Server service is running.
受保護的方法 CheckObjectState Checks the state of the referenced object. (繼承自 WmiSmoObject。)
受保護的方法 CreateProtocolPropertyCollection Creates a set of protocol attributes for the referenced object. (繼承自 WmiSmoObject。)
公用方法 Equals (繼承自 Object。)
受保護的方法 Finalize (繼承自 Object。)
公用方法 GetHashCode (繼承自 Object。)
受保護的方法 GetPropertyManagementObject Gets the management object for the specified protocol property. (繼承自 WmiSmoObject。)
受保護的方法 GetPropertyObject Gets the property from the specified collection with the specified position and value. (繼承自 WmiSmoObject。)
受保護的方法 GetProtocolPropertyCollection Returns the protocol property collection for the referenced object. (繼承自 WmiSmoObject。)
公用方法 GetType (繼承自 Object。)
受保護的方法 ImplInitialize Initializes the fields of the WmiSmoObjectobject. (繼承自 WmiSmoObject。)
公用方法 Initialize Initializes the referenced object. (繼承自 WmiSmoObject。)
受保護的方法 InvokeMgmtMethod(ManagementObject, String, array<Object> [] () [] []) Invokes the management method for the referenced object with the specified management object, method name, and parameters. (繼承自 WmiSmoObject。)
受保護的方法 InvokeMgmtMethod(ManagementObject, ManagementOperationObserver, String, array<Object> [] () [] []) Invokes the management method for the referenced object with the specified management object, observer, method name, and parameters. (繼承自 WmiSmoObject。)
受保護的方法 IsObjectInitialized Specifies whether the referenced object is initialized. (繼承自 WmiSmoObject。)
受保護的方法 MemberwiseClone (繼承自 Object。)
公用方法 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。)
受保護的方法 UpdateObjectState Updates the object state. (繼承自 WmiSmoObject。)
公用方法 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 為共用) 成員具備多執行緒作業安全。不保證所有執行個體成員都是安全執行緒。

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。