Simply run this code with a specified stored procedure name or comment out the where clause to show all stored procedures.
Simply run this code with a specified stored procedure name or comment out the where clause to show all stored procedures.
select SPECIFIC_NAME AS procedureName, SPECIFIC_CATALOG AS databaseName, CREATED AS createDate, LAST_ALTERED as lastAlteredDate from information_schema.routines where routine_name = '<Procedure Name Here>'