PublicationMonitor.EnumErrorRecords Method

Returns information about 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 ( _
    errorId As Integer _
) As DataSet
'Usage
Dim instance As PublicationMonitor 
Dim errorId As Integer 
Dim returnValue As DataSet 

returnValue = instance.EnumErrorRecords(errorId)
public DataSet EnumErrorRecords(
    int errorId
)
public:
DataSet^ EnumErrorRecords(
    int errorId
)
member EnumErrorRecords : 
        errorId:int -> DataSet
public function EnumErrorRecords(
    errorId : int
) : DataSet

Parameters

  • errorId
    Type: System.Int32
    An Int32 value specifying the ID value that uniquely identifies the error.

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

You should commit any property changes to the PublicationMonitor 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.

See Also

Reference

PublicationMonitor Class

Microsoft.SqlServer.Replication Namespace

Other Resources

NIB Programmatically Monitor Replication (RMO Programming)