sp_dumpparamcmd (T-SQL)

Returns detailed information for a parameterized command that has been stored in 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 results set. Long values may also be split across several rows in the results 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.

sp_browsereplcmds	sp_replshowcmds
sp_replcmds	System Stored Procedures