Post reply

How to get list of user defined stored procs from all databases...

  • February 17, 2006 at 2:32 pm

    #170697

    Hi All,

     I have list of my databases from master.dbo.sysobjects  and query to get list of stored proc  names from a given database like

    SELECT name

    FROM sysobjects

    WHERE 

       type ='P'

     AND 

       name not like 'dt_%' 

     ORDER BY name

    but unable to get all stored procs from All databases!!!

    Is there a way? Even looping thru each database and creating temp table is also ok. My database is SQL server 2000.

     

     

  • February 17, 2006 at 2:47 pm

    #621807

    sp_msforeachdb '?..sp_stored_procedures'

    sp_msforeachdb is an undocumented procedure

  • February 17, 2006 at 2:52 pm

    #621808

    EXEC sp_Msforeachdb "SELECT name FROM ?..sysobjects WHERE  type ='P' AND name not like 'dt_%'"

     

     

    -Krishnan

  • February 17, 2006 at 3:19 pm

    #621820

    Thanks for quick reply. Now I can add my more conditons to it. Thanks again.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply