Replication Subscription Status Constants (SQLDMO_SUBSTATUS_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.

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

Constant	Value	Description
SQLDMOSubStat_Active	2	The subscription is active. The agent maintains the subscription.
SQLDMOSubStat_Default	1000	SQLDMOSubStat_Unknown.
SQLDMOSubStat_Inactive	0	The subscription is inactive. The agent does not maintain the subscription.
SQLDMOSubStat_Max	2	SQLDMOSubStat_Active.
SQLDMOSubStat_Min	0	SQLDMOSubStat_Inactive.
SQLDMOSubStat_Unknown	1000	The subscription state cannot be determined.
SQLDMOSubStat_Unsynced	1	The subscription is not synchronized. Manual or automated synchronization must occur before an agent can maintain a subscription.