SELECT deqs.creation_time FROM sys.dm_exec_query_stats AS deqs;

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SELECT deqs.creation_time, dest.text
FROM sys.dm_exec_query_stats AS deqs
cross apply sys.dm_exec_sql_text(deqs.sql_handle) dest
where dest.text like '%PROCNAME%'

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass