Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sysreplicationalerts (Transact-SQL)
Collapse the table of content
Expand the table of content

sysreplicationalerts (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft