If you are using SQLServer, check out the docs on using Linked servers. this will give you the syntax for doing such a query.
It might be an idea though to wrap this up into a stored procedure. Pat "Jeremy" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 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/
