[dba-SQLServer]Update table in other db

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



More information about the dba-SQLServer mailing list