ReplicationMonitor.EnumErrorRecords Método

Artículo
02/02/2013

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

Espacio de nombres: Microsoft.SqlServer.Replication
Ensamblado: Microsoft.SqlServer.Rmo (en Microsoft.SqlServer.Rmo.dll)

Sintaxis

'Declaración
Public Function EnumErrorRecords ( _
    distributionDatabase As String, _
    errorId As Integer _
) As DataSet
'Uso
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

Parámetros

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

errorId
Tipo: System.Int32
An Int32 value that specifies the ID value that uniquely identifies the error.

Valor devuelto

Tipo: 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.

Comentarios

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.