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

You could raise an error during execution which will be logged in the
SQL error log.
M

You could raise an error during execution which will be logged in the
SQL errorlog.

M

[quoted text, click to view]


[quoted text, click to view]

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...

[quoted text, click to view]

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