Stored Procedures last access time?

Posted by Ardman on Stack Overflow See other posts from Stack Overflow or by Ardman
Published on 2010-03-01T13:28:13Z Indexed on 2010/03/23 11:23 UTC
Read the original article Hit count: 408

Is it possible to find out when a Stored Procedure was last accessed?

I tried the following:

SELECT * 
FROM sys.dm_db_index_usage_stats 
WHERE [database_id] = DB_ID()  
    AND [object_id] = OBJECT_ID('stored procedure name')

and it returns a blank resultset.

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about introspection