sql profiler for sql express 2008 that shows the query with parameter info

Question

Duplicate of: Does sql profiler show you the paramater values that were passed in? (Asked by same user.)

Hi,

I need a sql profiler that will show all the sql (raw sql or sproc) that are called to a database, along with the parameters passed into the queries.

I don't mind a commercial product if it has a trial.

Answer 1

Here is open source project I am using with SQL Server 2008 with great success: SqlExpressProfiler

Here is screenshot with parameter values:

Answer 2

You can checl xSQL Profiler at http://www.xsqlsoftware.com/Product/xSQL_Profiler.aspx It's free for SQL Express.