sp_browsereplcmds (Transact-SQL)

APPLIES TO: yesSQL Server yesAzure SQL Database (Managed Instance only) noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Returns a result set in a readable version of the replicated commands stored in the distribution database, and is used as a diagnostic tool. This stored procedure is executed at the Distributor on the distribution database.

Topic link icon Transact-SQL Syntax Conventions


sp_browsereplcmds [ [ @xact_seqno_start = ] 'xact_seqno_start' ]  
    [ , [ @xact_seqno_end = ] 'xact_seqno_end' ]   
    [ , [ @originator_id = ] 'originator_id' ]  
    [ , [ @publisher_database_id = ] 'publisher_database_id' ]  
    [ , [ @article_id = ] 'article_id' ]  
    [ , [ @command_id= ] command_id ]  
    [ , [ @agent_id = ] agent_id ]  
    [ , [ @compatibility_level = ] compatibility_level ]  


[ @xact_seqno_start = ] 'xact_seqno_start' Specifies the lowest valued exact sequence number to return. xact_seqno_start is nchar(22), with a default of 0x00000000000000000000.

[ @xact_seqno_end = ] 'xact_seqno_end' Specifies the highest exact sequence number to return. xact_seqno_end is nchar(22), with a default of 0xFFFFFFFFFFFFFFFFFFFF.

[ @originator_id = ] 'originator_id' Specifies if commands with the specified originator_id are returned. originator_id is int, with a default of NULL.

[ @publisher_database_id = ] 'publisher_database_id' Specifies if commands with the specified publisher_database_id are returned. publisher_database_id is int, with a default of NULL.

[ @article_id = ] 'article_id' Specifies if commands with the specified article_id are returned. article_id is int, with a default of NULL.

[ @command_id = ] command_id Is the location of the command in MSrepl_commands (Transact-SQL) to be decoded. command_id is int, with a default of NULL. If specified, all other parameters must be specified also, and xact_seqno_startmust be identical to xact_seqno_end.

[ @agent_id = ] agent_id Specifies that only commands for a specific replication agent are returned. agent_id is int, with a default value of NULL.

[ @compatibility_level = ] compatibility_level Is the version of Microsoft SQL Server on which the compatibility_level is int, with a default value of 9000000.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name Data type Description
xact_seqno varbinary(16) Sequence number of the command.
originator_srvname sysname Server where the transaction originated.
originator_db sysname Database where the transaction originated.
article_id int ID of the article.
type int Type of command.
partial_command bit Indicates whether this is a partial command.
hashkey 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. Used in peer-to-peer transactional replication.
command nvarchar(1024) Transact-SQL command.
command_id int ID of the command in MSrepl_commands.

Long commands can be split across several rows in the result sets.


sp_browsereplcmds is used in transactional replication.


Only members of the sysadmin fixed server role or members of the db_owner or replmonitor fixed database roles on the distribution database can execute sp_browsereplcmds.

See Also

sp_replcmds (Transact-SQL)
sp_replshowcmds (Transact-SQL)
System Stored Procedures (Transact-SQL)