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.