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.

See Also