Hi..
I m using sql server standard edition. I want to copy table data of 's1' from 'test1.dbo' into another table 's2'
which is exist in another database 'test2.dbo'. I m using import option to copy table data and the operation is done successfully but whenever I open table 's2'I got only one record of 's1' instead of getting all the records of 's1'into that table. Second thing is that the column name 'id' contain some same numbers in...