c4fe3653   
   XPost: microsoft.public.sqlserver.server   
   From: reb01501@NOyahoo.SPAMcom   
      
   tom12010 wrote:   
   > Can a SQL Server 2008 server have a linked server that is SQL Server   
   > 2008 R2??   
   >   
   > We presently use a SQL Server 2008 for reporting which links to a SQL   
   > 2005 server that will be replaced by a SQL 2008 R2 server, we need to   
   > link to a SQL Server 2008 R2 database from a SQL 2008 server.   
   >   
   > Note: The linked server is only used for selecting and reading data,   
   > not writes or edits/updates.   
   >   
   Why not? You can create a linked server to a database that isn't even   
   SQL Server.   
      
   The version of SQL Server at the other end of the pipe makes no   
   difference. It's the connecting software (Native Client, ODBC, OLE DB,   
   etc.) that's the limiting factor.   
      
   --   
   HTH,   
   Bob Barrows   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)