MSrepl_errors (Transact-SQL)
The MSrepl_errors table contains rows with extended Distribution Agent and Merge Agent failure information. This table is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
id |
int |
The ID of the error. |
time |
datetime |
The time the error occurred. |
error_type_id |
int |
Reserved for future use. |
source_type_id |
int |
The error source type ID. |
source_name |
nvarchar(100) |
The name of the error source. |
error_code |
sysname |
The error code. |
error_text |
ntext |
The error message. |
xact_seqno |
varbinary(16) |
The starting transaction log sequence number of the failed execution batch. Used only by the Distribution Agents, this is the transaction log sequence number of the first transaction in the failed execution batch. |
command_id |
int |
The command ID of the failed execution batch. Used only by the Distribution Agents, this is the command ID of the first command in the failed execution batch. |
session_id |
int |
The ID of the agent session in which the error occurred. |
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables