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