I have two databases on the same SQL Server 2005 server. There are
views and stored procedures in one database I'd like to copy to the
other one. What is the recommended way to accomplish this?

Thanks!
Jerry

Jer (jerry.w.black@saic.com) writes:
> I have two databases on the same SQL Server 2005 server. There are
> views and stored procedures in one database I'd like to copy to the
> other one. What is the recommended way to accomplish this?

To have all your source code under version control and build databases
from sources so you know what you build.

Else you could select all procedures in Object Explorer Details (F7) and
select a scripting alternative from the context menu. Same with views.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx