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.