Status Property (TargetServer)
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。 新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。
The Status property returns component execution or integrity state information.
構文
object.Status
Parts
- object
An expression that evaluates to an object in the Applies To list.
Data Type
Long
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetStatus(LPLONG pRetVal);
Returns
The Status property is returned as a bit-packed long. One or more of the following values can be returned.
Constant |
Value |
Description |
|---|---|---|
SQLDMOTargetServerStatus_/Blocked |
4 |
An instance of Microsoft SQL Server is visible. SQL Server Agent is blocked. |
SQLDMOTargetServerStatus_/Normal |
1 |
An instance of SQL Server is visible. SQL Server Agent is known to be running. |
SQLDMOTargetServerStatus_/SuspectedOffline |
2 |
An instance of SQL Server is visible. The execution state of SQL Server Agent cannot be determined. |
SQLDMOTargetServerStatus_/Unknown |
0 |
A network error is preventing determination of the state of the referenced server and SQL Server Agent. |