|
|
Posted by Erland Sommarskog on 08/22/06 22:18
kalaivanan (mail2kalai@gmail.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@sommarskog.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
Navigation:
[Reply to this message]
|