sp_browsereplcmds (Transact-SQL)
Applies to: SQL Server Azure SQL Managed Instance
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
Syntax
sp_browsereplcmds
[ [ @xact_seqno_start = ] N'xact_seqno_start' ]
[ , [ @xact_seqno_end = ] N'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 ]
[ ; ]
Arguments
[ @xact_seqno_start = ] N'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 = ] N'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
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_start must 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 of NULL
.
[ @compatibility_level = ] compatibility_level
Specifies the compatibility level of the SQL Server instance. @compatibility_level is int, with a default of 9000000
.
Return code values
0
(success) or 1
(failure).
Result set
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.
Remarks
sp_browsereplcmds
is used in transactional replication.
Permissions
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
.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru