Target Server Status Constants (SQLDMO_TARGETSERVERSTATUS_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Target server status constants interpret the return value of the Status property of the TargetServer object.
Constant |
Value |
Description |
|---|---|---|
SQLDMOTargetServerStatus_/Blocked |
4 |
A server running an instance of Microsoft SQL Server is visible. The SQL Server Agent service is blocked. |
SQLDMOTargetServerStatus_/Normal |
1 |
A server running an instance of SQL Server is visible. The SQL Server Agent service is known to be running. |
SQLDMOTargetServerStatus_/SuspectedOffline |
2 |
A server running an instance of SQL Server is visible. The SQL Server Agent service execution state cannot be determined. |
SQLDMOTargetServerStatus_/Unknown |
0 |
A network error prevents determination of the referenced server and the SQL Server Agent service. |