Hello everyone i m using SQL Server 2000, i want to copy tables with data from one Database to other in the same server. Kindly tell me is this possible with the DTS as in my 2nd database, there is no table, i want to copy from 1 db to other but not all tables, i need some tables. Kindly reply me how i do this. isa
