<div>
You should set up linked servers for this.<br />
<br />
Check this link for more info<br />
<br />
<a href="http://msdn2.microsoft.com/en-us/library/ms190479.aspx" rel="ugc">http://msdn2.microsoft.com/en-us/library/ms190479.aspx</a>
</div>


You should set up linked servers for this.

Check this link for more info

http://msdn2.microsoft.com/en-us/library/ms190479.aspx [http://msdn2.microsoft.com/en-us/library/ms190479.aspx]

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have two servers both windows 2003 and running sql server 2005. Each server has one database in it and I would like to know how I get a link table (or something similar) on server1 to a table on server2 so that I can run views on server1 which will pull data from server2?<br />
<br />
I've seen some info about sp_addlinkedserver but I don't know if that's what I want to use and if it is, how do I use it?<br />
<br />
Thanks for any help you can give me.<br />
Heather
</div>
</div>


Hi

I have two servers both windows 2003 and running sql server 2005. Each server has one database in it and I would like to know how I get a link table (or something similar) on server1 to a table on server2 so that I can run views on server1 which will pull data from server2?

I've seen some info about sp_addlinkedserver but I don't know if that's what I want to use and if it is, how do I use it?

Thanks for any help you can give me.
Heather

How do I link 2 sql server databases?

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.