[dba-SQLServer]Update table in other db

Thanks for the reply, Robert.

I've actually decided to avoid using a sproc for this part of my
project.

I can manually import the data into the SQL Server without a problem.

 

Thanks again,

Mark

 

-----Original Message-----
From: Djabarov, Robert [mailto:Robert.Djabarov at usaa.com] 
Sent: Tuesday, April 01, 2003 2:12 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Update table in other db

 

...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/ddc3fcdb/attachment.html>