Is there any way in SQL 7.0 to find out how often a stored procedure has been run? I could clearly do this myself but before I go to the effort I want to find out if maybe SQL Server is doing it for me already.
[sig][/sig]
There are several ways to check this. What I did was create a status table that would record getdate() Time started and Time completed of the sproc being run. I can refer to that table and check what has run, when and how long it took to run.
If you are speaking historically, try checking the task scheduler if the sproc's are automated and there's always the error and transaction logs.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.