Export (0) Print
Expand All

MergeSubscriberMonitor.GetSessionsSummaryDataSet Method

 

Applies To: SQL Server 2016 Preview

Returns summary information on Merge Agent sessions using a DataSet object.

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

NameDescription
System_CAPS_pubmethodGetSessionsSummaryDataSet()

Returns summary information on all Merge Agent sessions using a DataSet object.

System_CAPS_pubmethodGetSessionsSummaryDataSet(Int32)

Returns summary information for Merge Agent sessions that have occurred in the past number of hours specified. Summary information is returned using a DataSet object.

Call the GetSessionsSummary method to return the same data as an array of MergeSessionSummary objects.

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

Return to top

MergeSubscriberMonitor.GetSessionsSummaryDataSet Method ()

Returns summary information on all Merge Agent sessions using a DataSet object.

public DataSet GetSessionsSummaryDataSet()

Return Value

Type: System.Data.DataSet

A DataSet object.

Call the GetSessionsSummary method to return the same data as an array of MergeSessionSummary objects.

The GetSessionsSummaryDataSet() method returns DataRow objects for up to five sessions.

Calling the GetSessionsSummaryDataSet method is equivalent to executing sp_replmonitorhelpmergesession (Transact-SQL) at the Subscriber.

The GetSessionsSummaryDataSet method can be executed by members of the db_owner or replmonitor fixed database roles in the distribution database, when connected to the Distributor, or in the subscription database, when connected to the Subscriber.

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

Return to top

MergeSubscriberMonitor.GetSessionsSummaryDataSet Method (Int32)

Returns summary information for Merge Agent sessions that have occurred in the past number of hours specified. Summary information is returned using a DataSet object.

public DataSet GetSessionsSummaryDataSet(
	int hours
)

Parameters

hours
Type: System.Int32

The past number hours for which to return session information.

Return Value

Type: System.Data.DataSet

A DataSet object.

Call the GetSessionsSummary(Int32) method to return the same data as an array of MergeSessionSummary objects.

Calling the GetSessionsSummaryDataSet method is equivalent to executing sp_replmonitorhelpmergesession (Transact-SQL) at the Subscriber.

The GetSessionsSummaryDataSet method can be executed by members of the db_owner or replmonitor fixed database roles in the distribution database, when connected to the Distributor, or in the subscription database, when connected to the Subscriber.

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

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft