NoviceToDotNet NoviceToDotNet - 1 month ago 4
SQL Question

How to count all stored procedures in the SQL Server for a database?

How can I count all stored procedures which are written by me in my database?

Answer
select Count(*) from sys.procedures

And as Philip Kelley noted this is sql 2005 and up