Mark Boyd
MarkBoyd at McBeeAssociates.com
Tue Apr 1 11:36:17 CST 2003
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. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030401/61a13e5c/attachment.html>