MSpeer_response (Transact-SQL)

The MSpeer_response table is used in Peer-to-Peer replication to store each node's response to a publication status request. This table is stored in the publication database.

Definition

Column name Data type Description

request_id

int

Identifies a status request entry in the MSpeer_request table.

peer

sysname

The peer that generated the response.

peer_db

sysname

The subscription database at the peer that generated the response.

received_date

datetime

The Date and time that the peer response was sent.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance