sp_dumpparamcmd

Transact-SQL Reference

Transact-SQL Reference

sp_dumpparamcmd

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.

Syntax

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

Arguments

[@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.

Result Sets

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 C type information.
sqltype nvarchar(20) ODBC SQL 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.

Remarks

sp_dumpparamcmd is used in transactional replication.

Permissions

Only members of the sysadmin fixed server role can execute sp_ dumpparamcmd.

See Also

sp_browsereplcmds

sp_replcmds

sp_replshowcmds

System Stored Procedures