| title | sysreplicationalerts (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 6ed15828-8cca-4cf0-b2ff-1ecd0d8db11a | ||
| caps.latest.revision | 27 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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)