SELECT NAME,
lastdate
FROM (SELECT b.NAME,
Max(a.last_execution_time) AS lastdate
FROM sys.dm_exec_procedure_stats a
INNER JOIN sys.objects b
ON a.object_id = b.object_id
WHERE Db_name(a.database_id) = 'SkyPro'
GROUP BY b.NAME)z
--WHERE name LIKE 'SP_QA_LTM030_%'
ORDER BY name DESC
728x90
반응형
'DataBase > SQL Server' 카테고리의 다른 글
| DB 접속자 정보 조회 (0) | 2026.04.30 |
|---|---|
| DB Lock (0) | 2026.04.30 |
| Description 추가/수정 (0) | 2026.04.30 |
| 실행 이력 조회. (0) | 2026.04.30 |
| SSMS 한글 전환 버그 해결 SSMS PlayWith v0.92 (0) | 2025.04.09 |