MColeman
Programmer
- Sep 23, 2002
- 242
Does anyone know if there is a way to tell when a stored procedure last ran?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stored Procedure Run Date
- Thread starter MColeman
- Start date
- Status
No there is not unless you program a system of your own. You can run a trace on sps in profiler, but that takes extra memory and people do not generally run them at all times. And if you have not been running Profiler, then you cannot reconstruct past data.
You could put an insert statement into every sp to throw the sp name and date into a table. But again this adds a lot of overhead to your system and may not be a good idea as a permanent solution.
Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief
You could put an insert statement into every sp to throw the sp name and date into a table. But again this adds a lot of overhead to your system and may not be a good idea as a permanent solution.
Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief
- Status
Similar threads
- Locked
- Question