NoviceToDotNet NoviceToDotNet - 11 months ago 49
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 Source
select Count(*) from sys.procedures

And as Philip Kelley noted this is sql 2005 and up