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
이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.
예
WMI 공급자를 사용하여 서비스 및 네트워크 설정 관리
스레드 보안
이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.
참고 항목
참조
Microsoft.SqlServer.Management.Smo.Wmi 네임스페이스