MSpeer_response (Transact-SQL)
SQL Server 2005
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.
| 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. |
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System ViewsOther Resources
Integration Services TablesBackup and Restore Tables
Log Shipping Tables