<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.emailstyle17
{font-family:Tahoma;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle19
{font-family:Arial;
color:navy;}
span.EmailStyle20
{font-family:Arial;
color:#993366;}
span.EmailStyle21
{font-family:Tahoma;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=blue face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:blue'>Thanks for the reply, Robert.</span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:blue'>I’ve actually decided to avoid
using a sproc for this part of my project.</span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:blue'>I can manually import the data into the SQL
Server without a problem.</span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:blue'> </span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:blue'>Thanks again,</span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:blue'>Mark</span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:blue'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Djabarov, Robert
[mailto:Robert.Djabarov@usaa.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, April 01, 2003 2:12
PM<br>
<b><span style='font-weight:bold'>To:</span></b>
dba-sqlserver@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [dba-SQLServer]Update
table in other db</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><span class=EmailStyle20><font
size=2 color="#993366" face=Arial><span style='font-size:10.0pt'>…but you
need to create your sp on the side where INSERT occurs in order to use
OPENROWSET.</span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><span class=EmailStyle20><font
size=2 color="#993366" face=Arial><span style='font-size:10.0pt'> </span></font></span></p>
<p class=MsoAutoSig style='margin-left:.5in'><b><font
color=navy face="Courier New"><span style='font-family:"Courier New";
color:navy;font-weight:bold'>Robert Djabarov</span></font></b></p>
<p class=MsoAutoSig style='margin-left:.5in'><font size=3 color=navy
face="Courier New"><span style='font-size:12.0pt;font-family:"Courier New";
color:navy'>Senior SQL Server DBA</span></font></p>
<p class=MsoAutoSig style='margin-left:.5in'><font size=3 color=navy
face="Courier New"><span style='font-size:12.0pt;font-family:"Courier New";
color:navy'>USAA IT/DBMS</span></font></p>
<p class=MsoAutoSig style='margin-left:.5in'><font size=3 color=blue
face=Wingdings><span style='font-size:12.0pt;font-family:Wingdings;color:blue'>(</span></font><font
color="#993366" face="Courier New"><span style='font-family:"Courier New";
color:#993366'> </span></font><font color=blue face="Courier New"><span
style='font-family:"Courier New";color:blue'>(210) 913-3148 - phone</span></font></p>
<p class=MsoAutoSig style='margin-left:.5in'><font size=3 color=purple
face=Wingdings><span style='font-size:12.0pt;font-family:Wingdings;color:purple'>(</span></font><font
color="#993366" face="Courier New"><span style='font-family:"Courier New";
color:#993366'> </span></font><font color=purple face="Courier New"><span
style='font-family:"Courier New";color:purple'>(210) 753-3148 - pager</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><span class=EmailStyle20><font
size=2 color="#993366" face=Arial><span style='font-size:10.0pt'> </span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Djabarov, Robert <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, April 01, 2003 1:07
PM<br>
<b><span style='font-weight:bold'>To:</span></b>
dba-sqlserver@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [dba-SQLServer]Update
table in other db</span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=navy face=Arial><span style='font-size:10.0pt'>You can also use
OPENROWSET</span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=navy face=Arial><span style='font-size:10.0pt'> </span></font></span></p>
<p class=MsoAutoSig style='margin-left:1.0in'><b><font
color=navy face="Courier New"><span style='font-family:"Courier New";
color:navy;font-weight:bold'>Robert Djabarov</span></font></b></p>
<p class=MsoAutoSig style='margin-left:1.0in'><font size=3 color=navy
face="Courier New"><span style='font-size:12.0pt;font-family:"Courier New";
color:navy'>Senior SQL Server DBA</span></font></p>
<p class=MsoAutoSig style='margin-left:1.0in'><font size=3 color=navy
face="Courier New"><span style='font-size:12.0pt;font-family:"Courier New";
color:navy'>USAA IT/DBMS</span></font></p>
<p class=MsoAutoSig style='margin-left:1.0in'><font size=3 color=blue
face=Wingdings><span style='font-size:12.0pt;font-family:Wingdings;color:blue'>(</span></font><font
color=navy face="Courier New"><span style='font-family:"Courier New";
color:navy'> </span></font><font color=blue face="Courier New"><span
style='font-family:"Courier New";color:blue'>(210) 913-3148 - phone</span></font></p>
<p class=MsoAutoSig style='margin-left:1.0in'><font size=3 color=purple
face=Wingdings><span style='font-size:12.0pt;font-family:Wingdings;color:purple'>(</span></font><font
color=navy face="Courier New"><span style='font-family:"Courier New";
color:navy'> </span></font><font color=purple face="Courier New"><span
style='font-family:"Courier New";color:purple'>(210) 753-3148 - pager</span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=navy face=Arial><span style='font-size:10.0pt'> </span></font></span></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Mark Boyd
[mailto:MarkBoyd@mcbeeassociates.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, April 01, 2003
11:36 AM<br>
<b><span style='font-weight:bold'>To:</span></b> SQLServerList<br>
<b><span style='font-weight:bold'>Subject:</span></b> [dba-SQLServer]Update
table in other db</span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>I am
trying to create a sproc that appends records from TableA to TableB.</span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>TableA
is located on ServerA, and TableB is located on ServerB.</span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>How do
I specify the location of ServerB in the following statement?</span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>“INSERT
INTO TableB SELECT * FROM TableA”</span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'> </span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>TIA,</span></font></p>
<p class=MsoAutoSig style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>Mark
Boyd</span></font></p>
<p class=MsoAutoSig style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>Sr.
Systems Analyst</span></font></p>
<p class=MsoAutoSig style='margin-left:1.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>McBee
Associates, Inc.</span></font></p>
<p class=MsoNormal style='margin-left:1.5in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'> </span></font></p>
</div>
</body>
</html>