Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_browsereplcmds (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_browsereplcmds (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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. 

0 (success) or 1 (failure)

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.

Community Additions

ADD
Show:
© 2015 Microsoft