<div>
this can get you started: (let's say the servers are svr1 and svr2)<br />
on svr1<br />
sp_addlinkedserver 'svr2'<br />
then to run a query<br />
&nbsp; &nbsp; select top 10 * from svr2.database.dbo.tablenam<wbr />e<br />
you can even join to local tables, like<br />
&nbsp; &nbsp; select top 10 * from svr2.database.dbo.tablenam<wbr />e inner join dbo.localtable on ...<br />
<br />
check books online for sp_addlinkedserver. the example above will use the current login (to svr1) to authenticate with svr2. so if you're on a domain and using windows authentication, shouldn't be a problem
</div>


this can get you started: (let's say the servers are svr1 and svr2)
on svr1
sp_addlinkedserver 'svr2'
then to run a query
    select top 10 * from svr2.database.dbo.tablename
you can even join to local tables, like
    select top 10 * from svr2.database.dbo.tablename inner join dbo.localtable on ...

check books online for sp_addlinkedserver. the example above will use the current login (to svr1) to authenticate with svr2. so if you're on a domain and using windows authentication, shouldn't be a problem

<div>
i am getting this error The OLE DB provider &quot;MSDASQL&quot; has not been registered.
</div>


i am getting this error The OLE DB provider "MSDASQL" has not been registered.

<div>
<div class="content wysiwyg-content">
i am using sql server 2005. i have another database which is on the other network. and i have odbc connection settings if i want to link to that database in my sql how can i link that database and start writing queries.
</div>
</div>


i am using sql server 2005. i have another database which is on the other network. and i have odbc connection settings if i want to link to that database in my sql how can i link that database and start writing queries.

SQL 2005 connectiion link

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.