Udostępnij za pośrednictwem


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
public DataSet EnumErrorRecords (
    int errorId
)
public:
DataSet^ EnumErrorRecords (
    int errorId
)
public DataSet EnumErrorRecords (
    int errorId
)
public function EnumErrorRecords (
    errorId : int
) : DataSet

Parameters

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

Return Value

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.

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

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

PublicationMonitor Class
PublicationMonitor Members
Microsoft.SqlServer.Replication Namespace

Other Resources

How to: Programmatically Monitor Replication (RMO Programming)