<div>
Excellent Erick37!! worked a charm! you have saved me a lot of time! can go home now!!
</div>


Excellent Erick37!! worked a charm! you have saved me a lot of time! can go home now!!

<div>
<div class="content wysiwyg-content">
Hi,<br />
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 &quot;copy&quot; option in the sub menu (see pic below)..<br />
my question is what is the easiest way to create an exact duplicate &quot;test&quot; stored procedure...I just want &nbsp;the same procedure with a new name .<br />
thanks<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2010/11_w49/374854/copySP.bmp" target="_blank" title="spMenu (960 KB)"><img alt="spMenu" class="file-block lazyload" style="max-width: 640px;" data-src="https://filedb.experts-exchange.com/incoming/2010/11_w49/374854/copySP.bmp" /></a>
</div>
</div>


copySP.bmp

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

 

copying stored procedure in ms sql 2005 management studio

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.