inserting values from a table to another

Hello,

There is a known issue reported with SQL 2008 and SQL 2008 R2 :

Please check if we are not hitting this known issue:

FIX: Query failure and an "Invalid column name" error message occur when you run a linked server query to another instance of SQL Server 2008 or SQL Server 2008 R2

http://ift.tt/1q2T3ca

Fix:

Cumulative update package 10 for SQL Server 2008 Service Pack 1

Cumulative update 1 for SQL Server 2008 Service Pack 2

Cumulative Update package 5 for SQL Server 2008 R2

---

Regards, Don Rohan [MSFT]

I am using sql 2012