sp_dumpparamcmd (Transact-SQL)

Returns detailed information for a parameterized command that has been stored in the distribution database. This stored procedure is executed at the Distributor on the distribution database.

Topic link icon Transact-SQL Syntax Conventions



sp_dumpparamcmd [ @originator_id=] 'originator_id', [ @publisher_database_id =] 'publisher_database_id', [ @article_id =] 'article_id', [ @xact_seqno =] 'xact_seqno'

[ @originator_id=] 'originator_id'

Is the originator_id for which to return parameterized commands. originator_id is int, with no default.

[ @publisher_database_id=] 'publisher_database_id'

Is the publisher_database_id for which to return parameterized commands. publisher_database_id is int, with no default.

[ @article_id=] 'article_id'

Is the article_id for which to return parameterized commands. article_id is int, with no default.

[ @xact_seqno=] 'xact_seqno'

Is the exact sequence number for which to display parameterized commands. xact_seqno is nchar(22), with no default.

sp_dumpparamcmd is a diagnostic procedure used to retrieve detailed information on parameterized commands within a single transaction. sp_dumpparamcmd returns two result sets for each parameterized command within the transaction.

Column name Data type Description

bytes

int

Number of bytes of Transact-SQL.

params

smallint

Number of parameters in the statement.

command

nvarchar(1024)

Transact-SQL command.

Note:
Long commands may be split across several rows in the result set. Long values may also be split across several rows in the result set.

The second result set contains one or more rows for each parameter.

Column name Data type Description

paramid

smallint

ID of the parameter.

offset

int

Byte offset within the data stream.

repltype

nvarchar(20)

Type information.

storage

nvarchar(20)

Storage information.

align

int

Alignment of data.

ctype

nvarchar(20)

ODBC Microsoft Visual C type information.

sqltype

nvarchar(20)

ODBC Microsoft SQL Server type information.

prec

int

Precision of the value.

scale

smallint

Scale of the value.

token_fragment

nvarchar(1024)

Displays the value stored in this token in a text format.

sp_dumpparamcmd is used in transactional replication.

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

Community Additions

Show: