how to get all stored procedures in sql server code example
Example: sql script get all stored procedures from database
SELECT
SCHEMA_NAME(schema_id) AS [Schema],
name
FROM sys.objects
WHERE type = 'P';
SELECT
SCHEMA_NAME(schema_id) AS [Schema],
name
FROM sys.objects
WHERE type = 'P';