ReplicationDatabase.EnumTransConflictCounts Method

Returns information on conflicts stored in an updating transactional publication or subscription database.

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

Syntax

'Declaration
Public Function EnumTransConflictCounts ( _
    publicationName As String, _
    publisherName As String, _
    publicationDB As String _
) As IEnumerable
'Usage
Dim instance As ReplicationDatabase
Dim publicationName As String
Dim publisherName As String
Dim publicationDB As String
Dim returnValue As IEnumerable

returnValue = instance.EnumTransConflictCounts(publicationName, _
    publisherName, publicationDB)
public IEnumerable EnumTransConflictCounts(
    string publicationName,
    string publisherName,
    string publicationDB
)
public:
IEnumerable^ EnumTransConflictCounts(
    String^ publicationName, 
    String^ publisherName, 
    String^ publicationDB
)
member EnumTransConflictCounts : 
        publicationName:string * 
        publisherName:string * 
        publicationDB:string -> IEnumerable 
public function EnumTransConflictCounts(
    publicationName : String, 
    publisherName : String, 
    publicationDB : String
) : IEnumerable

Parameters

  • publicationName
    Type: System.String
    The name of the publication. publicationName is a required parameter.
  • publisherName
    Type: System.String
    The name of the Publisher server. publisherName is only supported on Microsoft SQL Server 2005 and later versions.
  • publicationDB
    Type: System.String
    The name of the published database. publicationDB is only supported on SQL Server 2005 and later versions.

Return Value

Type: System.Collections.IEnumerable
An ArrayList of TransConflictCount objects.

Remarks

The EnumTransConflictCounts method can be called when connected to a subscription database that supports queued updating. Conflict information for queued updating Subscribers can be retrieved from the publication database by calling EnumTransConflictCounts and supplying null values for the publicationDB or publisherName parameters. For more information, see Queued Updating Conflict Detection and Resolution.

The EnumTransConflictCounts method can only be called by members of the sysadmin fixed server role, by members of the db_owner fixed database role, or by users in the publication access list (PAL).