Combining 2 databases as one

Hi,
We need to combine 2 databases as one on SQL Server 2000. One database has
wickedly many View tables and the other has more wickedly many Stored
Procedures. What would be the best way to combine them.
YCScript the objects in one of the database and use the script to create the o
bjects in the other
database. And test, test, test. Also see: http://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"YC" <asppsa@.hotmail.com> wrote in message news:%23I0KtzDhGHA.1276@.TK2MSFTNGP03.phx.gbl...[v
bcol=seagreen]
> Hi,
> We need to combine 2 databases as one on SQL Server 2000. One database ha
s wickedly many View
> tables and the other has more wickedly many Stored Procedures. What would
be the best way to
> combine them.
> YC
>[/vbcol]