<div>
In Management Studio, you can copy stored procedures between databases. However, as far as instance to instance, I don't think it is possible. &nbsp;You would have to right click the stored procedure, script stored procedure as, create to, and either file or new query window. &nbsp;Then copy that to the new instance and add the stored procedure.<br />
<br />
Stored Procedures are more of a database specific thing. &nbsp;Are you talking about a DMV?
</div>


In Management Studio, you can copy stored procedures between databases. However, as far as instance to instance, I don't think it is possible.  You would have to right click the stored procedure, script stored procedure as, create to, and either file or new query window.  Then copy that to the new instance and add the stored procedure.

Stored Procedures are more of a database specific thing.  Are you talking about a DMV?

<div>
<div class="content wysiwyg-content">
What is the script to copy all sp frm 1 server to other?
</div>
</div>


What is the script to copy all sp frm 1 server to other?

How to copy all stored procedure from one server to another.

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.