Discussion in 'SQL Server 2008 General Developer Questions' started by crprajan, Feb 23, 2009.
How to count the number of stored procedures inside a database using an sql query?
* from sys.procedures -- to list out all the SPs in a databaseselect
COUNT(*) from sys.procedures -- to get the count of the SPs in a database
COUNT(*) from information_schema.routines where
Homework question? 
Hey! Thank you very much. It is working fine
Thank you so much. It is working fine
you can also use this..select
count(*) from sys.sysobjectswhere
xtype = 'P'
Separate names with a comma.