hehe

yah i noticed that...

and i did this statement in sql query after i built the tables

thank you

well i have created a table just the same as the on in Database A and i used the second query you listed

INSERT INTO Noor.dbo.NTasks SELECT * FROM 706.dbo.GVTDPTASKS

but...

well thanx am gonna try it

but no i only created the 2nd DB i still didnot build any tables in it.??

well thx for your reply 😉

i want to use the transact sql but i want the syntax so i can copy the data from one db to another then to...