Share via

MergeSubscriberMonitor.GetSessionsSummaryDataSet Method

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Replication
Assembly:
Microsoft.SqlServer.Rmo.dll

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

Overloads

GetSessionsSummaryDataSet()

Returns summary information on all Merge Agent sessions using a DataSet object.
GetSessionsSummaryDataSet(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.

Remarks

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.

GetSessionsSummaryDataSet()

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

public:
 System::Data::DataSet ^ GetSessionsSummaryDataSet();
public System.Data.DataSet GetSessionsSummaryDataSet ();
member this.GetSessionsSummaryDataSet : unit -> System.Data.DataSet
Public Function GetSessionsSummaryDataSet () As DataSet

Returns

DataSet

A DataSet object.

Remarks

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.

Applies to

GetSessionsSummaryDataSet(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:
 System::Data::DataSet ^ GetSessionsSummaryDataSet(int hours);
public System.Data.DataSet GetSessionsSummaryDataSet (int hours);
member this.GetSessionsSummaryDataSet : int -> System.Data.DataSet
Public Function GetSessionsSummaryDataSet (hours As Integer) As DataSet

Parameters

hours
Int32

The past number hours for which to return session information.

Returns

DataSet

A DataSet object.

Remarks

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.

Applies to