Condividi tramite


Status Property (MergeArticle)

Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa caratteristica in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

The Status property returns component execution or integrity state information.

Sintassi

object
.Status [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.

  • value
    A long integer that identifies the status of the referenced component as described in Settings.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetStatus(SQLDMO_ARTSTATUS_TYPE* pRetVal);
HRESULT SetStatus(SQLDMO_ARTSTATUS_TYPE NewValue);

Settings

Constant

Value

Description

SQLDMOArtStat_Active

2

The article is active.

SQLDMOArtStat_Conflicts

3

Conflicting copies of article data exist.

SQLDMOArtStat_Errors

4

Agent attempts to publish the article or resolve conflicts in copies of the article have resulted in errors.

SQLDMOArtStat_Inactive

0

The article is inactive.

SQLDMOArtStat_Unsynced

1

An initial snapshot of article has not been made or has not been retrieved by all Subscribers.

Applies To: