Question: how to copy data from one table to another sql server 2008?
Answer: Right Click on the Database -> Tasks -> Export Data., Select the source/target Database., Select source/target table and fields., Copy the data.