Djabarov, Robert
Robert.Djabarov at usaa.com
Tue Apr 1 13:12:22 CST 2003
...but you need to create your sp on the side where INSERT occurs in order to use OPENROWSET. Robert Djabarov Senior SQL Server DBA USAA IT/DBMS * (210) 913-3148 - phone * (210) 753-3148 - pager -----Original Message----- From: Djabarov, Robert Sent: Tuesday, April 01, 2003 1:07 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Update table in other db You can also use OPENROWSET Robert Djabarov Senior SQL Server DBA USAA IT/DBMS * (210) 913-3148 - phone * (210) 753-3148 - pager -----Original Message----- From: Mark Boyd [mailto:MarkBoyd at mcbeeassociates.com] Sent: Tuesday, April 01, 2003 11:36 AM To: SQLServerList Subject: [dba-SQLServer]Update table in other db 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/58fb222f/attachment-0001.html> -------------- next part -------------- _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com