Status Property (TargetServer)
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The Status property returns component execution or integrity state information.
Syntaxe
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. |