<div>
When u right click on it and select copy, it copies the script of the sp to clipboard.......<br />
<br />
get all the scripts and paste them into a file, then execute the script in the query analyzer.....<br />
<br />
Lemme know how it went buddy!<br />
<br />
HTH<br />
<br />
<br />
<br />

</div>


When u right click on it and select copy, it copies the script of the sp to clipboard.......

get all the scripts and paste them into a file, then execute the script in the query analyzer.....

Lemme know how it went buddy!

HTH





<div>
<div class="content wysiwyg-content">
I have got to be overlooking something... Surely it can't be that difficult to copy stored procedures and views from one database to another on the same server. &nbsp;Seems strange that I can right-mouse click and select copy, but when I move down to the other database there isn't any &quot;Paste&quot; option.<br />
I am working on SQL Server 2000. I don't want to move tables, just SP, Views, And Functions. &nbsp;What is the EASIST way to do this?
</div>
</div>


I have got to be overlooking something... Surely it can't be that difficult to copy stored procedures and views from one database to another on the same server.  Seems strange that I can right-mouse click and select copy, but when I move down to the other database there isn't any "Paste" option.
I am working on SQL Server 2000. I don't want to move tables, just SP, Views, And Functions.  What is the EASIST way to do this?

Copy Stored Procedures from one database to another

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.