مشاركة عبر

  • مقالة

ReplicationMonitor.EnumErrorRecords Method

Returns information on errors associated with a specified error ID that occurred during a synchronization session.

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

Syntax

'Declaration
Public Function EnumErrorRecords ( _
    distributionDatabase As String, _
    errorId As Integer _
) As DataSet
'Usage
Dim instance As ReplicationMonitor
Dim distributionDatabase As String
Dim errorId As Integer
Dim returnValue As DataSet

returnValue = instance.EnumErrorRecords(distributionDatabase, _
    errorId)

public DataSet EnumErrorRecords(
    string distributionDatabase,
    int errorId
)

public:
DataSet^ EnumErrorRecords(
    String^ distributionDatabase, 
    int errorId
)

member EnumErrorRecords : 
        distributionDatabase:string * 
        errorId:int -> DataSet 

public function EnumErrorRecords(
    distributionDatabase : String, 
    errorId : int
) : DataSet

Parameters

  • distributionDatabase
    Type: System.String
    A String value that specifies the distribution database.

Return Value

Type: System.Data.DataSet
A DataSet object that contains the following columns.

Column

Data type

Description

source_type_id

Int32

Identifies the source of the error.

source_name

String

The name of the error source.

error_code

String

The error code.

error_text

String

The message text for the error.

(No column name)

String

Date and time that the error occurred.

error_type_id

Int32

Type of error that occurred.

has_xact_seqno

Boolean

If the error has a corresponding transaction log sequence number.

xact_seqno

Byte[]

The starting transaction log sequence number of the failed execution batch.

command_id

Int32

The command ID of the first command in the failed execution batch.

Remarks

Commit any property changes to the ReplicationMonitor object before calling this method, because properties of this object may need to be loaded if they have not been loaded already.

The EnumErrorRecords method can only be called by members of the db_owner or replmonitor fixed database roles on the distribution database.

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