Linked SQL Servers

Pulling data from tables on different servers

I have a join between a table on my local database and a table on a different database on the same server. I reference the non-local database with DatabaseName.TableName. Now I find that the non-local database might be on a different server. I tried ServerName.DatabaseName.TableName, but I got this...

sql server remote server connection

What is the best way to access a sql server in another country using the public ip address? I tried linked server unsuccesfully. Please help. Thanks.

Linked SQLServer

Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.

Lotus Notes to SQL Server 2005 via linked server

I am trying to create a linked server on SQL Server 2005 to Lotus Notes 6.03. However, I keep getting an error. A system dsn was created with the Lotus NotesSQL driver (8.0). In creating the linked server on SQL Server 2005, Linked Server Name: Same name as System DSN Provider: Microsoft OLE DB...

Linked server problems

I have 2 servers Server 1 has sql 2000 (SP2) Server 2 has SQl 2000 + SQL 2005 (sp2) Im trying to create a linked server on Server 1 to Server 2 SQL 2005 I can get SQL 2005 linked into SQL 2000 on server 2 itself but when i got to Server 1 and try to create alinked server to SQl 2005 i get...