Freigeben über


Status Property (TargetServer)

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The Status property returns component execution or integrity state information.

Syntax

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.

Applies To: