Data Modification via Linked Server

• paksu

  Valued Member

  Points: 74

  More actions

  July 25, 2003 at 11:08 am

  #80917

  I am on SQL 2000, SP3, and I have a linked server which is accessing a Sybase 11.9.2 ASE server. Querying via the linked server seems to work grand, but I have found no information on how to structure an INSERT or UPDATE statement to modify data. I would like to do something like: INSERT INTO <linked server table> SELECT * FROM <local table>.

  Thanks

• paksu

  Valued Member

  Points: 74

  More actions

  July 25, 2003 at 3:32 pm

  #467153

  I guess I was using a generic ODBC driver. I changed to the Sybase System 11 driver and I was fine.