SQL SERVER – 2005 – List All Stored Procedure in Database

Run following simple script on SQL Server 2005 to retrieve all stored procedure in database.

SELECT
*
FROM sys.procedures;

This will ONLY work with SQL Server 2005.

Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Scripts, SQL Stored Procedure
Previous Post
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
Next Post
SQL SERVER – Correct Syntax for Stored Procedure SP

Related Posts

66 Comments. Leave new

  • How can I find stored procedures that have never been executed. Not only in the time the log persists in memory? Any idea?
    If is not posible I am trying to find out how to save the number of times the stored procedures of my database are executed. Any help please. It is driving me crazy!! Maybe there is a table where all this information is saved.

    Reply
  • Morteza Kermani
    April 3, 2012 11:49 am

    List Stored Procedures including plain script.

    Reply
  • Morteza Kermani
    April 3, 2012 11:49 am

    List Stored Procedures including plain script:

    SELECT r.ROUTINE_NAME, r.Routine_Definition
    FROM INFORMATION_SCHEMA.Routines r order by r.ROUTINE_NAME

    Reply
  • Avinash Ranjan (@avinash_t)
    June 18, 2012 11:35 am

    thanks and it was very helpful and new to me other than sp_help

    Reply
  • I need to copy a store procedures to txt file, by coding only

    Reply
  • How to find DBName using ‘SPname’ in sql on which DB it exists.

    Reply
  • SELECT * FROM SYSOBJECTS WHERE XTYPE IN (‘P’,’X’) AND category=0 ORDER BY NAME

    Reply
  • HOW CAN I RESOLVE THIS
    list the titles, prices and advances
    of all the books with the
    price greater than 20% of the advance
    thanks

    Reply
  • Hi,

    I need to pull the all userdefined object info from one database.

    User defined objects – Tables,index,constraints ,SP,Functions Triggers….

    i want the output as below

    DBName ObjectName ObjectType …..

    Can anyone help me please

    Reply
  • I have a phantom stored procedure that keeps running. How do i find and delete this phantom stored procedure?

    Reply
  • Dear sir,

    I have received one database from client i had made changes like, create,insert,update, delete, in table and stored procedures, could you please help me how to find the things which i had updated by using any query…

    Reply
  • Hi Pinal,

    Can you please tell me, how to get the list of user stored procedure that are not executed for long time or unused user stored procedure.

    Reply
  • any one help me how can i find difference for two database like find stored procedure , table, function.. is there any tool or query ?

    Reply
  • Kazi Nizamuddin
    January 31, 2015 6:33 pm

    All stored numbers got lost deleted from phone memory

    Reply

Leave a Reply