Transact-SQL Reference
sysreplicationalerts
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 | ID of the alert. |
| status | int | User-defined value:
0 = Unserviced |
| agent_type | int | Type of agent:
1 = Snapshot Agent |
| agent_id | int | Agent ID from the tables MSsnapshot_agents, MSlogreader_agents, MSdistribution_agents, or MSmerge_agents. |
| error_id | int | ID of the error stored in MSrepl_errors. |
| alert_error_code | int | Message ID of the alert raised when logging this record. |
| time | datetime | Time the record was inserted. |
| publisher | sysname | Name of the Publisher associated with the agent that fired this alert. |
| publisher_db | sysname | Publisher database associated with the agent that fired this alert. |
| publication | sysname | Publication associated with the agent that fired this alert. |
| publication_type | int | Type of publication: 0 = Snapshot 1 = Transactional 2 = Merge |
| subscriber | sysname | Name of the Subscriber associated with the agent that fired this alert. |
| subscriber_db | sysname | Name of the Subscriber database associated with the agent that fired this alert. |
| article | sysname | Name of the article associated with the agent that fired this alert. |
| destination_ object |
sysname | Name of the subscription table associated with the alert. |
| source_object | sysname | Name of the published table associated with the alert. |
| alert_error_text | ntext | Text of the alert. |