To get all stored procedures from database then we can use following command
GO
SELECT name,type_Desc,create_Date,Modify_Date
FROM sys.procedures WHERE type=’p’
AND type_desc =’SQL_STORED_PROCEDURE’
GO
GO
SELECT name,type_Desc,create_Date,Modify_Date
FROM sys.procedures WHERE type=’p’
AND type_desc =’SQL_STORED_PROCEDURE’
GO
Or we can use following command
GO
SELECT ROUTINE_NAME,ROUTINE_TYPE,ROUTINE_DEFINITION,CREATED,LAST_ALTERED
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE =’PROCEDURE’
Enjoy !!!
