MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

Re: How To Check When Store Procedure Executed Last Time

It showing me today executed store procedure can i able to see store procedure that are not run from the past one month i have more then 150 store procedure i dont know which is currently using and which not in use..?

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

Re: How To Check When Store Procedure Executed Last Time

If you need further help please tell us which SQL Server edition you are using. For SQL Server 2008, AUDIT is available in the developer/enterprise edition. Else we would have to use extended events...