SQL-DMO
Target Server Status Constants (SQLDMO_TARGETSERVERSTATUS_TYPE)
Target server status constants interpret the return value of the Status property of the TargetServer object.
| Constant | Value | Description |
|---|---|---|
| SQLDMOTargetServerStatus_Blocked | 4 | Server running an instance of Microsoft® SQL Server™ is visible. SQL Server Agent service is blocked. |
| SQLDMOTargetServerStatus_Normal | 1 | Server running an instance of SQL Server is visible. SQL Server Agent service is known to be running. |
| SQLDMOTargetServerStatus_SuspectedOffline | 2 | Server running an instance of SQL Server is visible. SQL Server Agent service execution state cannot be determined. |
| SQLDMOTargetServerStatus_Unknown | 0 | Network error prevents determination of referenced server and SQL Server Agent service. |