sysreplicationalerts (Transact-SQL)

Applies to: SQL Server

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.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)