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: 407
sql-server-2008
|introspection
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