Linked SQL Servers Questions and Answers

Recent IT Questions

1 - 5 of 5
<<PREVIOUS 1 NEXT>>

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...

View Answer   |  Oct 8 2009  5:53 PM GMT
Linked SQL Servers, SQL Database, SQL error messages
asked by CO Bill

  70 pts.

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.

View Answer   |  Jul 2 2009  5:03 AM GMT
Linked SQL Servers, SQL Server Remote Connections
asked by Preethibh

  5 pts.

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.

asked by Db23

  230 pts.

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...

Answer Question   |  Mar 26 2009  1:50 PM GMT
Lotus Notes 6.x, Linked SQL Servers, SQL Server 2005
asked by Awaller

  5 pts.

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...

View Answer   |  Mar 5 2009  2:34 PM GMT
Linked Server, SQL Server 2000, SQL Server 2005
asked by KH

  50 pts.

1 - 5 of 5
<<PREVIOUS 1 NEXT>>