In SQL Server Management Studio navigate to your database.

Right click it and select “Tasks” -> “Generate Scripts”
“Next”
Select your database from the list
“Next” Select “Stored Procedures” “Next”
“Select All” “Next”
“Script to new Query Window” “Next”
“Finish”

Give it a while. Then when complete, at the very top of the script put “use (yourdatabase)”

Execute the use statement.
Execute the whole script.