TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sysreplicationalerts (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 nameData typeDescription
alert_idintThe ID of the alert.
statusintThe user-defined value:

 0 = Unserviced.

 1 = Serviced.
agent_typeintType of agent:

 1 = Snapshot Agent.

 2 = Log Reader Agent.

 3 = Distribution Agent.

 4 = Merge Agent.
agent_idintThe agent ID from the tables MSsnapshot_agents, MSlogreader_agents, MSdistribution_agents, or MSmerge_agents.
error_idintThe ID of the error stored in MSrepl_errors.
alert_error_codeintThe message ID of the alert raised when logging this record.
timedatetimeThe time the record was inserted.
publishersysnameThe name of the Publisher associated with the agent that fired this alert.
publisher_dbsysnameThe publisher database associated with the agent that fired this alert.
publicationsysnameThe publication associated with the agent that fired this alert.
publication_typeintThe type of publication:

 0 = Snapshot.

 1 = Transactional.

 2 = Merge.
subscribersysnameThe name of the Subscriber associated with the agent that fired this alert.
subscriber_dbsysnameThe name of the Subscriber database associated with the agent that fired this alert.
articlesysnameThe name of the article associated with the agent that fired this alert.
destination_objectsysnameThe name of the subscription table associated with the alert.
source_objectsysnameThe name of the published table associated with the alert.
alert_error_textntextThe text of the alert.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft