sysreplicationalerts (Transact-SQL)
Contains information about the conditions causing a replication alert to fire. This table is stored in the msdb database.
|
Column name |
Data type |
Description |
|---|---|---|
|
alert_id |
int |
The ID of the alert. |
|
status |
int |
The user-defined value: 0 = Unserviced. 1 = Serviced. |
|
agent_type |
int |
Type of agent: 1 = Snapshot Agent. 2 = Log Reader Agent. 3 = Distribution Agent. 4 = Merge Agent. |
|
agent_id |
int |
The agent ID from the tables MSsnapshot_agents, MSlogreader_agents, MSdistribution_agents, or MSmerge_agents. |
|
error_id |
int |
The ID of the error stored in MSrepl_errors. |
|
alert_error_code |
int |
The message ID of the alert raised when logging this record. |
|
time |
datetime |
The time the record was inserted. |
|
publisher |
sysname |
The name of the Publisher associated with the agent that fired this alert. |
|
publisher_db |
sysname |
The publisher database associated with the agent that fired this alert. |
|
publication |
sysname |
The publication associated with the agent that fired this alert. |
|
publication_type |
int |
The type of publication: 0 = Snapshot. 1 = Transactional. 2 = Merge. |
|
subscriber |
sysname |
The name of the Subscriber associated with the agent that fired this alert. |
|
subscriber_db |
sysname |
The name of the Subscriber database associated with the agent that fired this alert. |
|
article |
sysname |
The name of the article associated with the agent that fired this alert. |
|
destination_object |
sysname |
The name of the subscription table associated with the alert. |
|
source_object |
sysname |
The name of the published table associated with the alert. |
|
alert_error_text |
ntext |
The text of the alert. |
