sp_browsereplcmds (T-SQL)

Returns a result set in a readable format of the replicated commands stored in the distribution database.

Syntax

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]

Arguments

[@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 for which to return information. xact_seqno_end is nchar(22), with a default of 0xFFFFFFFFFFFFFFFFFFFF.

[@originator_id =] 'originator_id'

Is whether commands with the specified originator_id are returned. originator_id is int, with a default of NULL.

[@publisher_database_id =] 'publisher_database_id'

Is whether commands with the specified publisher_database_id are returned. publisher_database_id is int, with a default of NULL.

[@article_id =] 'article_id'

Is whether 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 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.

Result Sets

sp_browsereplcmds is a diagnostic utility used to examine replicated commands stored in the distribution database. sp_browsereplcmds returns this result set.

Long commands can be split across several rows in the results set.

Remarks

sp_browsereplcmds is used in transactional replication.

Permissions

Only members of the sysadmin fixed server role can execute sp_browsereplcmds.

See Also