United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Replication)

Microsoft.SqlServer.Replication

AddColumnOption Enumeration

AgentJobHistoryInfo Class

AgentProfile Class

AgentProfileParameter Class

AgentProfileParameterInfo Class

AgentProfileTypeOption Enumeration

AgentType Enumeration

Article Class

ArticleConflict Class

ArticleDatatypeMappingOptions Enumeration

ArticleOptions Enumeration

AuthenticationMethod Enumeration

AutomaticReinitializationPolicies Enumeration

BusinessLogicHandler Class

CheckPermissionOptions Enumeration

CommandOptions Enumeration

ConflictPolicyOption Enumeration

ConnectionSecurityContext Class

CreationScriptOptions Enumeration

CustomResolver Class

DatabaseCompatibilityLevel Enumeration

DdlReplicationOptions Enumeration

DistributionArticle Class

DistributionArticleCollection Class

DistributionDatabase Class

DistributionDatabaseCollection Class

DistributionPublication Class

DistributionPublicationCollection Class

DistributionPublisher Class

DistributionPublisherCollection Class

DistributionSubscription Class

DistributionSubscriptionCollection Class

DtsPackageLocationOption Enumeration

FailoverMode Enumeration

FilterTypes Enumeration

HeterogeneousColumn Class

HeterogeneousTable Class

IConnectionSecurityContext Interface

IdentityRangeInfo Class

IdentityRangeManagementOption Enumeration

InitialSyncType Enumeration

IProcessSecurityContext Interface

IReplicationDBObject Interface

LastValidationDateTime Class

LightPublication Class

MergeArticle Class

MergeArticleCollection Class

MergeArticleState Enumeration

MergeConflictCount Class

MergeDynamicSnapshotJob Class

MergeJoinFilter Class

MergePartition Class

MergePublication Class

MergePublicationCollection Class

MergePullSubscription Class

MergePullSubscriptionCollection Class

MergeSessionDetail Class

MergeSessionDetailType Enumeration

MergeSessionError Class

MergeSessionPhase Enumeration

MergeSessionStatus Enumeration

MergeSessionSummary Class

MergeSubscriberMonitor Class

MergeSubscriberType Enumeration

MergeSubscription Class

MergeSubscriptionCollection Class

MonitorCacheRefreshPolicy Enumeration

MonitorThreshold Class

PartitionGroupsOption Enumeration

PartitionOptions Enumeration

PendingCommandInfo Class

PreCreationOption Enumeration

Publication Class

PublicationAccess Class

PublicationArticle Class

PublicationAttributes Enumeration

PublicationCompatibilityLevel Enumeration

PublicationMonitor Class

PublicationMonitorCollection Class

PublicationType Enumeration

PublisherConnectionSecurityContext Class

PublisherMonitor Class

PublisherMonitorCollection Class

PullSubscription Class

QueueOption Enumeration

RegisteredSubscriber Class

RegisteredSubscriberCollection Class

ReplicationAgentSchedule Class

ReplicationBaseCollection Class

ReplicationColumn Class

ReplicationDatabase Class

ReplicationDatabaseCollection Class

ReplicationMonitor Class

ReplicationObject Class

ReplicationSchemaBoundView Class

ReplicationSecurityMode Enumeration

ReplicationServer Class

ReplicationStatus Enumeration

ReplicationStatusAndWarning Class

ReplicationStoredProcedure Class

ReplicationTable Class

ReplicationUserDefinedAggregate Class

ReplicationUserDefinedFunction Class

ReplicationView Class

ReplicationWarnings Enumeration

ResynchronizeType Enumeration

RetentionPeriodUnits Enumeration

ScheduleConstant Enumeration

ScheduleFrequencySubDay Enumeration

ScheduleFrequencyType Enumeration

ScheduleRelativeIntervals Enumeration

ScriptOptions Enumeration

State Enumeration

SubscriberSubscription Class

SubscriberType Enumeration

SubscriberUploadOptions Enumeration

Subscription Class

SubscriptionBackupDeviceType Enumeration

SubscriptionBackupInformation Class

SubscriptionResultOption Enumeration

SubscriptionState Enumeration

SubscriptionSyncType Enumeration

SynchronizationPartner Class

TracerToken Class

TransArticle Class

TransArticleCollection Class

TransConflictCount Class

TransPublication Class

TransPublicationCollection Class

TransPullSubscription Class

TransPullSubscriptionCollection Class

TransSubscriberType Enumeration

TransSubscription Class

TransSubscriptionCollection Class

ValidationMethod Enumeration

ValidationOption Enumeration

VerifyResolverSignatureOption Enumeration

Minimize

This topic has not yet been rated - Rate this topic

SubscriptionResultOption Enumeration

SQL Server 2012

Enumerates options for returning monitored subscriptions.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public enum SubscriptionResultOption

	Member name	Description
	AllSubscriptions	Returns all subscriptions.
	InErrorOnly	Returns subscriptions with an error status.
	InWarningOnly	Returns subscriptions with a warning status.
	InErrorAndWarningOnly	Returns subscriptions with an error or warning status.
	Top25WorstPerforming	Returns the top 25 worst performing subscriptions.
	Top50WorstPerforming	Returns the top 50 worst performing subscriptions.
	Synchronizing	Returns subscriptions that are currently synchronizing.
	NotSynchronizing	Returns subscriptions that are not currently synchronizing.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

Reference

Microsoft.SqlServer.Replication Namespace

EnumSubscriptions

EnumSubscriptions

EnumSubscriptions2

EnumSubscriptions

Other Resources

Monitoring (Replication)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.