MS SQL 2008 - Transfering data to external remote SQL
Posted on 2011-09-14
Here is what I am try to do.
SQL1 - run a procedure that will first of all delete all records on a remote SQL2 table
then update from SQL1 to the remote SQL2 table.
I have tried using ODBC with no success... I would like to have something like below...
INSERT INTO SQL2(column1, column2)
FROM SQL1(column1, column2)
My problem is my remote sql is the folloing. SQLB33.webcontrolcenter.com
and my sql database is SQL2 with table user