SQL Server Profile - View Parameter Values?

sql-server sql-server-profiler
Tyllyn picture Tyllyn · Dec 10, 2008 · Viewed 18.5k times · Source

In SQL Server Profile, I have it tracing SP:StmtStarting events. The "TextData" includes information like the following:

EXEC MySortedProc 
   @param, NULL,
   @param2, NULL

What would I have to trace (or can I?) to view the value of those parameters?

Answer

Tone picture Tone · Jun 25, 2009

Somewhat scared to have misunderstood the question, but you could profile on the RPC:Completed event which will return the result for stored procedure execution in the textdata column like:

exec usp_yourproc @param = 'value'

Related questions

SQL Server Profiler - How to filter trace to only display events from one database?

How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.

Read More
Where is SQL Profiler in my SQL Server 2008?

I downloaded SQL Server 2008 and can't seem to find SQL Profiler anywhere. I believe I installed the SQL Server Enterprise Express/trial version? I guess it was Express and not Enterprise after all right?

Read More
What does "exec sp_reset_connection" mean in Sql Server Profiler?

Trying to understand what Sql Profiler means by emitting "sp_reset_connection". I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed, RPC:Completed exec sp_reset_connection SQL:BatchStarting SELECT [c].[TestID] AS [TestID], [c].[…

Read More