• if you just want the stored procedures and no data, probably your best bet is scripting:

    From within Management Studio, in the Object Explorer, expand your database, expand the Programmability folder, and select "Stored Procedures" folder. Then press the F7 key to open the Object Explorer Details page. From there, you can select all or as many stored procs as you want, right click, then select "Script Stored Procedure as > Create To > File..."