SQL Server Performance

count the number of stored procedures

Discussion in 'SQL Server 2008 General Developer Questions' started by crprajan, Feb 23, 2009.

  1. crprajan New Member

    How to count the number of stored procedures inside a database using an sql query?
    please help
    crprajan, Feb 23, 2009
    #2

  2. johnson_ef Member

    HI Rajan,
    Try this:select
    * 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
    Regards
    -Johnson
    johnson_ef, Feb 23, 2009
    #3

  3. Madhivanan Moderator

    Alsoselect
    COUNT(*) from information_schema.routines where
    routine_type='procedure'
    Madhivanan, Feb 25, 2009
    #4

  4. FrankKalis Moderator

    Homework question? [;)]
    FrankKalis, Feb 25, 2009
    #5

  5. crprajan New Member

    Hey! Thank you very much. It is working fine
    crprajan, Mar 2, 2009
    #6

  6. crprajan New Member

    Thank you so much. It is working fine
    crprajan, Mar 2, 2009
    #8

  7. Sandy New Member

    you can also use this..select
    count(*) from sys.sysobjectswhere
    xtype = 'P'
    Thanks,
    Sandy.
    Sandy, Mar 2, 2009
    #9

Share This Page