<div>
Nominate one server as a remote and setup a linked server in the other to this remote server. Then use the four part naming convention -<br />
<br />
&nbsp;[server].[database].[owner<wbr />/schema].[<wbr />tablename]<wbr /><br />
<br />
to reference the remote table in the subquery..
</div>


Nominate one server as a remote and setup a linked server in the other to this remote server. Then use the four part naming convention -

 [server].[database].[owner/schema].[tablename]

to reference the remote table in the subquery..

<div>
Sorry Brandon, didn't see your post when I started responding to this question..
</div>


Sorry Brandon, didn't see your post when I started responding to this question..

<div>
No big deal. &nbsp;You were typing while I was. &nbsp;
</div>


No big deal.  You were typing while I was.  

<div>
<div class="content wysiwyg-content">
I have two different databases (both MS SQL Server) where I search for employees:<br />
<br />
&nbsp; &nbsp;conn1.ConnectionString = (connectionstring to db on server 1)<br />
&nbsp; &nbsp;conn2.ConnectionString = (connectionstring to db on server 2)<br />
&nbsp; &nbsp;conn1.Open<br />
&nbsp; &nbsp;conn2.open<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp; &nbsp;sqlstr=&quot;SELECT employee.name FROM db_on_server1<br />
&nbsp; &nbsp;WHERE employee.id IN (SELECT persons.id FROM db_on_server2 WHERE ...)&quot;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp; &nbsp;Set rs = Server.CreateObject(&quot;ADODB<wbr />.Recordset<wbr />&quot;)<br />
&nbsp; &nbsp;rs.open sqlstr, conn1<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Works fine when the two databases was on the same SQL server with just one connection string, but now one of them was moved to another server.<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Is it possible to subquery like above, when the subquery targets a db on another server, or is there another way of doing this?
</div>
</div>


I have two different databases (both MS SQL Server) where I search for employees:

   conn1.ConnectionString = (connectionstring to db on server 1)
   conn2.ConnectionString = (connectionstring to db on server 2)
   conn1.Open
   conn2.open
	
   sqlstr="SELECT employee.name FROM db_on_server1
   WHERE employee.id IN (SELECT persons.id FROM db_on_server2 WHERE ...)"
	
   Set rs = Server.CreateObject("ADODB.Recordset")
   rs.open sqlstr, conn1
	
Works fine when the two databases was on the same SQL server with just one connection string, but now one of them was moved to another server.
	
Is it possible to subquery like above, when the subquery targets a db on another server, or is there another way of doing this?

SQL/ASP: Recordset from two different servers with vbscript

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.