title: How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
body: <p>Currently I am working on SQL Server 2000,2005 &amp; 2008, my requirement is like,
  the database available in SQL Server 2000 &amp; 2005 will be available in 2008 using a linked server.</p>
  
  <p>Let's say I have a database in SQL Server 2000 called <code>LIVE_2000</code> and in SQL Server 2005 it's called <code>LIVE_2005</code>, can someone please help me to create the linked server for <code>LIVE_2000</code> and <code>LIVE_2005</code> into SQL Server 2008?</p>
  
  <p>1st thing is this even possible?</p>
  
  <p>Thanks in advance...`</p>