sp_replcmds (Transact-SQL)

Artykuł
02/13/2015

Returns the commands for transactions marked for replication. This stored procedure is executed at the Publisher on the publication database.

Ważne:
The sp_replcmds procedure should be run only to troubleshoot problems with replication.

Ikona łącza do tematu Transact-SQL Syntax Conventions

Składnia

sp_replcmds [ @maxtrans = ] maxtrans

Arguments

[ @maxtrans=] maxtrans
Is the number of transactions to return information about. maxtrans is int, with a default of 1, which specifies the next transaction waiting for distribution.

Result Sets

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.

Uwagi

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.

[!UWAGA]

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.