| title | sp_browsereplcmds (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 30abcb41-1d18-4f43-a692-4c80914c0450 | ||
| caps.latest.revision | 34 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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.
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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion] 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) | [!INCLUDEtsql] 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.
sp_replcmds (Transact-SQL)
sp_replshowcmds (Transact-SQL)
System Stored Procedures (Transact-SQL)