<div>
If databases are on the same server it is as simple as using longer names of the tables<br />
<br />
databaseA.schema.tableA<br />
databaseB.schema.tableB<br />
<br />
default schema is dbo.<br />
<br />
if the database are on different servers you will need to use linked servers
</div>


If databases are on the same server it is as simple as using longer names of the tables

databaseA.schema.tableA
databaseB.schema.tableB

default schema is dbo.

if the database are on different servers you will need to use linked servers

<div>
Linked servers are new to me -- but after reading the URL, it seems to be the answer.
</div>


Linked servers are new to me -- but after reading the URL, it seems to be the answer.

<div>
<div class="content wysiwyg-content">
I'd prefer to *not* use MS Business Integration Studio.<br />
<br />
Can I, in one stored procedure, pull data from table A in database A and then insert the results into table B in database B?<br />
<br />
Is it as simple as using &quot;USE&quot; to identify the source and then the target?<br />
<br />
Thanks
</div>
</div>


I'd prefer to *not* use MS Business Integration Studio.

Can I, in one stored procedure, pull data from table A in database A and then insert the results into table B in database B?

Is it as simple as using "USE" to identify the source and then the target?

Thanks

Pulling from a MSSQL 2005 db on a remote server and inserting results into our MSSQL 2005 tables

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.