This article is tagged with:
Sql script get all stored procedures from database
and mysql
sql script get all stored procedures from database
SELECT
SCHEMA_NAME(schema_id) AS [Schema],
name
FROM sys.objects
WHERE type = 'P';