What tool to capture values passed into SQL Server procedure

I have a DLL,开发者_高级运维 for which I do not have the source code. It is making calls to a stored procedure in a SQL Server 2005 database. I need to know what values it is passing in as the parameters of the call.

Is there a free tool, or one that comes with SQL Server that is able to monitor and record the calls into a database?

Thanks.

You can use for this SQL Server Profiler which comes with SQL Server.

If you have an access to Microsoft SQL Server Management Studio, you find it by clicking Tools → SQL Server Profiler.

When it starts, click Connect. On Trace properties dialog, click Run. It then collects every call to the SQL Server and displays the summary at the top, and the query with its parameters at the bottom of the window.

You can also:

• Pause or stop the profiler (icons in the toolbar),
• Clear the current trace.

Do not forget to clear the trace before launching the action which will call the stored procedure and do not forget to pause/stop the profiling after you get the results to avoid getting too much information to analyze.

As pointed in the comments, if you are using SQL Server Express, the profiler may be missing. You may want to install a third party profiler for SQL Express instead.

Check the [Tools] menu in SQL Server Management Studio:

If you don't see this option, you most likely have SQL Server EXPRESS which does not come with Profiler.