write MS SQL query to copy data from one table in one database to a table in unrelated database

Hi, i can copy MSSQL DB! I'm ready to start working right now. My experience in web-dev and administration of the Linux and Windows system is more than 7 years!

I hope i can figure it out. Let me review the system and try to do it as challengeable task. Thank you for your opportunity. RoyalCalif

Hello. I have good skills in Database Administration, Microsoft Access, Microsoft SQL Server, MySQL, SQL. I'm interest to your project. Contact me please. Thanks.

hello i am keen to do this project for you, either if you give me the access to both server i can do it mhyself or grant me access over team viewer and i can work from your computer to do the job for you. third option is to guide you and you do it yourself, let me know which mode you prefer.

till tomortpw u will have this query

Systems Engineer with 10 years of experience in Administration, Management and Development of applications for Multinational Companies in Guatemala, Technical Support and IT, Networks.

You dont need to pay for that, just search the "Link Server" option in the object explorer and add SourceServer to the DestinationServer. Then just write: SELECT * INTO newtable FROM [SourceServer].oldtable;

your work will be done within a day that is just couple of hours after the project will be assigned .