<div>
It's some overhead, but I usually write them to a table at the very start of the proc. &nbsp;Naturally you can comment that code out when you no longer need it.
</div>


It's some overhead, but I usually write them to a table at the very start of the proc.  Naturally you can comment that code out when you no longer need it.

<div>
It might make it null but mostly it is not. Is it a one time requirement? If yes, profiler will still be the best option.
</div>


It might make it null but mostly it is not. Is it a one time requirement? If yes, profiler will still be the best option.

<div>
I've requested that this question be deleted for the following reason:<br />
<br />
found it myself
</div>


I've requested that this question be deleted for the following reason:

found it myself

<div>
I offered a very useful alternative, which the other responder did not.<br />
<br />
What is the answer the original asker is using?
</div>


I offered a very useful alternative, which the other responder did not.

What is the answer the original asker is using?

<div>
<div class="content wysiwyg-content">
I have a stored procedure I want to review the parameters being passed. Some blogs say that profiler might display null values, What is the best way to determine the actual values being passed to your stored procedure?
</div>
</div>


I have a stored procedure I want to review the parameters being passed. Some blogs say that profiler might display null values, What is the best way to determine the actual values being passed to your stored procedure?

viewing parameters in stored procedure

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.