By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,317 Members | 1,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,317 IT Pros & Developers. It's quick & easy.

Is logging the execution time of Stored Procedures with standard settings possible?

P: n/a
Dear group,

is it possible in SQL-Server to see when a stored procedure was
executed ?

I would say it is only possible with some traces but not with the
standard settings.

For a short answer on that matter i'd be thankful.

Regards

Uli

Oct 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
You could raise an error during execution which will be logged in the
SQL error log.
M

Oct 13 '05 #2

P: n/a
You could raise an error during execution which will be logged in the
SQL errorlog.

M

Oct 13 '05 #3

P: n/a
>You could raise an error during execution which will be logged in the
SQL errorlog.
M


I want to have some possibility to see when a SP has been executed,
without changing the database in any way. Unfortunately there seems to
be no such possibility...

Oct 13 '05 #4

P: n/a
ul*********@lycos.at wrote:
You could raise an error during execution which will be logged in the
SQL errorlog.


M


I want to have some possibility to see when a SP has been executed,
without changing the database in any way. Unfortunately there seems to
be no such possibility...


What's the problem in running a trace filtering on this specific SP? Or
do you need to have this logged long term? That'll be harder. If you
have only a single ODBC client you might be able to cook something up with
the ODBC trace but I doubt this is a viable solution.

robert

Oct 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.