EnumAgentErrorRecords Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The EnumAgentErrorRecords method returns a QueryResults object that enumerates a specified replication agent error.

Syntax

object
.EnumAgentErrorRecords(
ErrorID
)
as 
QueryResults

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

  • ErrorID
    Long integer that identifies an error.

Prototype (C/C++)

HRESULT EnumAgentErrorRecords(LONG ErrorID
LPSQLDMOQUERYRESULTS* ppResults);

Returns

A QueryResults object that contains one result set defined by these columns.

Column

Data type

Description

error_time

nvarchar(26)

Date and time at which error occurred.

error_code

nvarchar(129)

Error code.

error_text

ntext

Error message.

error_type_id

integer

Reserved.

source_name

nvarchar(101)

Name of error source.

source_type_id

integer

Identifier of type of error source.

Remarks

Interpret the value of the source_type_id column using these values.

source_type_id value

Error source

0

Undefined or unable to determine.

1

Replication command. error_textcolumn contains command.

2

Replication agent.

3

Operating system error.

4

ODBC.

5

Data source, such as Microsoft SQL Server.

6

SQL Server Net-Library.

7

SQL Distributed Management Objects (SQL-DMO).