In EM, right-click on the db in question, select All tasks, Generate SQL script, select 'Show all', check 'All Stored Procedures. Then choose the other option you'd like, and there you go.