data transfer

[kalaivanan]

hi,
My problem is I am creating a new database. I need to all the tables
and procedures from
one databse to another database in sql server 2000, both in same
server.

Kalaivanan.

[Erland Sommarskog]

Re: data transfer

kalaivanan (mail2kalai@gma il.com) writes:

My problem is I am creating a new database. I need to all the tables
and procedures from
one databse to another database in sql server 2000, both in same
server.

In Enterprise Manager, right-click the database, and select Tasks. In
this submenu you find Generate scripts.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx