Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaysysreplicationalerts (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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)