title: Backup Stored Procedures
body: <p>Currently, if I want to make a backup of a stored procedure, using Mircosoft SQL Server Management Studio 2008 R2, I right click on my stored procedure, choose modify and then in the stored procedure change alter proc part to create proc, and add the word "backup" to the end of the name of the stored procedure.  Is there a better way to do this?  In a perfect world, I would like to be able to backup all the stored procedures in a database and keep them maybe somewhere locally. I don't like how my list of stored procedures is getting sloppy (for lack of a better word) with all these backups I have made.  If you can't tell, I am exteremly new to writing stored procedures and want to be able to have this to safeguard the existing stored procedures from any mistakes I might make.</p>
  
  <p>Thanks in advance for all your help!</p>