How to count all stored procedures in the SQL Server for a database?
select Count(*) from sys.procedures
And as Philip Kelley noted this is sql 2005 and up
-- Information about table --
SELECT * FROM sys.sysobjects WHERE xtype = 'U'
-- Information about Stored Procedure --
SELECT * FROM sys.sysobjects WHERE xtype = 'P'
-- Information about Functions --
SELECT * FROM sys.sysobjects WHERE xtype = 'FN'
-- Information about Views --
SELECT * FROM sys.sysobjects WHERE xtype = 'V'
To get the Stored Procedure count:
SELECT COUNT(*) SPCOUNT
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='PROCEDURE'
or:
SELECT COUNT(*)
FROM sys.procedures
or:
SELECT COUNT(*)
FROM sys.sysobjects
WHERE xtype = 'P'
Hope one of these help.