NoviceToDotNet NoviceToDotNet - 1 year ago 72
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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download