后续版本的 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. |