How to generate all the store procedures of a database in SQL Server 2005/2008.

1. connect to the server
2. right click the database

3. go to tasks --> generate scripts
4. then you will get the dialog box as below and follow the steps

start page

select the database

just click next

select what ever script you need to generate

select the name of the store procedure or a table depending on your selection