copying stored procedure in ms sql 2005 management studio

Hi,
I want to copy a stored procedure in Microsoft SQL Server Management Studio 2005 to make some mods without destroying the original...havnt done this before and was expecting a "copy" option in the sub menu (see pic below)..
my question is what is the easiest way to create an exact duplicate "test" stored procedure...I just want  the same procedure with a new name .
thanks

 spMenu
blossomparkAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Erick37Connect With a Mentor Commented:
Select "Script Stored Procedure As..." then "Create to New Query Window"

Once the script opens, change the name of the procedure in the script and execute.
0
 
blossomparkAuthor Commented:
Excellent Erick37!! worked a charm! you have saved me a lot of time! can go home now!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.