EnumAgentErrorRecords Method

SQL-DMO

SQL-DMO

EnumAgentErrorRecords Method

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

Applies To
DistributionDatabase2 Object DistributionPublisher Object
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
  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_text column contains command.
2 Replication agent.
3 Operating system error.
4 ODBC.
5 Data source, such as Microsoft® SQL Server™ 2000.
6 SQL Server Net-Library.
7 SQL-DMO.