Script Download:GetAllStoredProcedures.zip
http://gallery.technet.microsoft.com/scriptcenter/How-to-retrieve-all-the-7e2e5287/view/Reviews

This T-SQL script will help us get the codes of stored procedures in a specified database.  After you run this script, you’ll notice that the codes of stored procedures you need will show in the Messages pane.

A lot of people asked for methods to get the codes of stored procedures in a specified database.  Some people want to save the codes so that they can run these codes in other databases.

 

image image
image

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery