471,075 Members | 910 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Tracing Stored Procedure (SP) Usage

Hi,

what I am trying to discern is if there is any way of logging SP
activity on a SQL server 2k DB. Ideally I would want to log SP name,
parameters, user and time.

I found sp_monitor in MSDN but that just gives overall statistics.
Not specific enough to aid debugging.

Thanks in advance,

Finlay Macrae
Jul 20 '05 #1
1 2485
"Finlay" <f_******@hotmail.com> wrote in message
news:50**************************@posting.google.c om...
Hi,

what I am trying to discern is if there is any way of logging SP
activity on a SQL server 2k DB. Ideally I would want to log SP name,
parameters, user and time.

I found sp_monitor in MSDN but that just gives overall statistics.
Not specific enough to aid debugging.

Thanks in advance,

Finlay Macrae


The best place to start is probably by using SQL Profiler to trace the
various SP events, which can be logged to a file or table for analysis.
Traces can also be run on the server side using the sp_trace% procedures -
see BOL for more details.

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by C Kirby | last post: by
2 posts views Thread by Dino L. | last post: by
45 posts views Thread by John | last post: by
4 posts views Thread by lokesh.kris | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.