Francisco H Tapia
my.lists at verizon.net
Tue Apr 1 11:42:26 CST 2003
INSERT INTO ServerB.DatabaseName.dbo.TableB SELECT * FROM TableA note that you have to add a linked server to ServerA see BOL about Linked Servers. -Francisco http://rcm.netfirms.com On Tuesday, April 01, 2003 9:36 AM [GMT-8], Mark Boyd <MarkBoyd at mcbeeassociates.com> wrote: : I am trying to create a sproc that appends records from TableA to : TableB. : : TableA is located on ServerA, and TableB is located on ServerB. : : How do I specify the location of ServerB in the following statement? : : "INSERT INTO TableB SELECT * FROM TableA" : : : : TIA, : : Mark Boyd : : Sr. Systems Analyst : : McBee Associates, Inc. : : : : : : : :: _______________________________________________ :: dba-SQLServer mailing list :: dba-SQLServer at databaseadvisors.com :: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver :: http://www.databaseadvisors.com