This article is tagged with:
Sql copy stored procedures to another server
and mysql
sql copy stored procedures to another server
Go the server in Management Studio.
Select the database, right click on it Go to Task.
Select generate scripts option under Task.
and once its started select the desired stored procedures you want to copy.
