Replication Subscription Status Constants (SQLDMO_SUBSTATUS_TYPE)

SQL-DMO

SQL-DMO

Replication Subscription Status Constants (SQLDMO_SUBSTATUS_TYPE)

Replication subscription status constants specify subscription activity, controlling action by a replication agent maintaining the subscription.

Constant Value Description
SQLDMOSubStat_Active 2 Subscription is active. Agent will maintain subscription.
SQLDMOSubStat_Default 1000 SQLDMOSubStat_Unknown.
SQLDMOSubStat_Inactive 0 Subscription is inactive. Agent will not maintain subscription.
SQLDMOSubStat_Max 2 SQLDMOSubStat_Active.
SQLDMOSubStat_Min 0 SQLDMOSubStat_Inactive.
SQLDMOSubStat_Unknown 1000 Subscription state cannot be known.
SQLDMOSubStat_Unsynced 1 Subscription is not synchronized. Manual or automated synchronization must occur before agent can maintain subscription.