Home Forums SQL Server 2005 Administering Script all Stored procs for all databases on a server RE: Script all Stored procs for all databases on a server

  • December 9, 2010 at 11:56 am

    #1260719

    I found it myself and it is:

    EXECUTE sp_msforeachdb 'select specific_catalog, specific_name, routine_definition from information_schema.routines'