vellezz.info

SELECT * FROM sys.objects
WHERE type = 'P' 
and name ='proc_name'

albo trochę dłuższa wersja

SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo' 
and SPECIFIC_NAME = 'proc_name'
order by  LAST_ALTERED desc