Bagikan melalui


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.

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

Syntax

'Declaration
Public Function GetSessionsSummaryDataSet ( _
    hours As Integer _
) As DataSet
'Usage
Dim instance As MergeSubscriberMonitor
Dim hours As Integer
Dim returnValue As DataSet

returnValue = instance.GetSessionsSummaryDataSet(hours)
public DataSet GetSessionsSummaryDataSet(
    int hours
)
public:
DataSet^ GetSessionsSummaryDataSet(
    int hours
)
member GetSessionsSummaryDataSet : 
        hours:int -> DataSet 
public function GetSessionsSummaryDataSet(
    hours : int
) : DataSet

Parameters

  • hours
    Type: System.Int32
    The past number hours for which to return session information.

Return Value

Type: System.Data.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.