.png)
sp_replcmds (Transact-SQL)
Returns the commands for transactions marked for replication. This stored procedure is executed at the Publisher on the publication database.
 Important |
|---|
The sp_replcmds procedure should be run only to troubleshoot problems with replication. |
Column name | Data type | Description |
|---|---|---|
article id | int | The ID of the article. |
partial_command | bit | Indicates whether this is a partial command or not. |
command | varbinary(1024) | The command value. |
xactid | binary(10) | Transaction ID. |
xact_seqno | varbinary(16) | The transaction sequence number. |
publication_id | int | The ID of the publication. |
command_id | int | ID of the command in MSrepl_commands. |
command_type | int | Type of command. |
originator_srvname | sysname | Server where the transaction originated. |
originator_db | sysname | Database where the transaction originated. |
pkHash | int | Internal use only. |
originator_publication_id | int | ID of the publication where the transaction originated. |
originator_db_version | int | Version of the database where the transaction originated. |
originator_lsn | varbinary(16) | Identifies the log sequence number (LSN) for the command in the originating publication. |
sp_replcmds is used by the log reader process in transactional replication.
Replication treats the first client that runs sp_replcmds within a given database as the log reader.
This procedure can generate commands for owner-qualified tables or not qualify the table name (the default). Adding qualified table names allows replication of data from tables owned by a specific user in one database to tables owned by the same user in another database.
| Note |
|---|
Because the table name in the source database is qualified by the owner name, the owner of the table in the target database must be the same owner name. |
Clients who attempt to run sp_replcmds within the same database receive error 18752 until the first client disconnects. After the first client disconnects, another client can run sp_replcmds, and becomes the new log reader.
A warning message number 18759 is added to both the Microsoft SQL Server error log and the Microsoft Windows application log if sp_replcmds is unable to replicate a text command because the text pointer was not retrieved in the same transaction.
