Status Property (TargetServer)

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

Applies To: