Hi, I asked this before but I'm thinking it passed through the gaps and no one read it. So I'll post one more time. If no one responds then I will assume it can't be done.
I have two servers both located in seperate locations. Server A has a table which I would like to copy and insert into Server B. What is the SQL syntax to achieve this? Currenly I have SELECT * INTO table_a (located at server B) FROM table_a (located at server A) I have tried to alter the FROM statement to have the server name i.e. FROM serverA.DatbaseName.TableA However this didn't work. Any ideas anyone? Jeremy --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
