Home Forums SQL Server 2008 T-SQL (SS2K8) counting the number of stored procedures RE: counting the number of stored procedures
steveb.
SSC-Forever
Points: 46733
More actions
February 23, 2009 at 4:59 am
#948513
use Sysobjects
SELECT COUNT(*) FROM sys.sysobjects
WHERE xtype = 'p'