Re: Capturing stored procedures parameters

Tech-Archive recommends: Fix windows errors by optimizing your registry

This can easily be done using SQL Profiler. Just establish a new trace
using one of the SQLProfilerTSQL_xxxx templates. If you are only looking to
trace a single procedure, then you should probably play with the filter
criteria to eliminate some of the background noise otherwise you'll need to
wade through all of the TSQL commands being executed.

--
--Brian
(Please reply to the newsgroups only.)


"Daniel Corrêa" <daniel.correa@xxxxxxxxxxxxxxx> wrote in message
news:esZKlWeoFHA.1948@xxxxxxxxxxxxxxxxxxxxxxx
> Is it possible to capture, via trace or other means, the value of the
> parameters passed to a stored procedure? There is a stored procedure in
> the SharePoint database I want to monitor, but I don't want to change it.
> I want to know when it's called and what parameters were passed to it.
>
> Thank you in advance,
> Daniel
>


.

Relevant Pages

  • SqlDataAdapter.Fill returns results of previous command
    ... This code executes successfully at certain points in the application, ... I don't know what the cause of this exception is yet, ... stored procedure was indeed executed on the database. ... The trace shows that the last action on the db was the stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: fn_trace_gettable threatening my sanity
    ... solution is so ridiculous as to be unbelievable: my stored procedure ... by the procedure that created the trace. ... with the file type added by the ... uppercase and one with lowercase to see the problem behavior and ...
    (microsoft.public.sqlserver.server)
  • Re: Stored Procedures Data view webparts
    ... The only way I have found to get any type of trace is to use SQL Profiler. ... I've had a stored procedure created that works in the following way ... Having the following issues basically i get a generic error message ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SQL Debugging
    ... You can run a trace using Sql Profiler. ... - Sahil Malik ... > I am able to run a stored procedure with no parameters, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Log everything
    ... from the trace I can see that probably an error occurs in a trigger. ... trigger does a rollback tran (and with that makes it impossible to put some ... >> I would like to log every error that occurs in every stored procedure ...
    (microsoft.public.sqlserver.programming)