• From within SQL-EM, highlight the list of stored procedures within the database.

    After right click and choosing Tasks-->Generate SQL Scripts, the "Generate SQL Scripts" window appears.

    the [General] tab will show those objects to be scripted

    switch to the [Options] tab. The bottom right corner has an option to script all selected objects as one file or one file per object.

    When you click the OK button it will ask for the folder into which each file will be saved. stored procedures will have a .PRC extension

    -----

    Robert