Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Last Time Executed

Author  Topic 

JamesT
Yak Posting Veteran

97 Posts

Posted - 2004-01-06 : 14:31:10
Is there a way, either by Information Schema or other method, to determine the last time a stored procedure was executed?

Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-06 : 14:32:14
You would need to be running SQL Profiler to capture it. This information is not stored anywhere, so you have to run a trace to see what is occurring.

Tara
Go to Top of Page

JamesT
Yak Posting Veteran

97 Posts

Posted - 2004-01-06 : 14:32:44
Bummer. Thanks however.
Go to Top of Page
   

- Advertisement -