Linked server allows operation to multiple server as one query.

learn more… | top users | synonyms

5
votes
1answer
237 views

SQL Server Linked server query problem (group by)

I have been using an old SQL Server 2000 installation for a long time that is linked to several Oracle servers, and it all works very well. I am trying to migrate to SQL Server 2012 via SQL Server ...
2
votes
2answers
493 views

Query intermittently fails with “The multi-part identifier could not be bound”

I've got Schrodinger's query here; you can run it once successfully, then 5 times in a row, and it works fine. Change anything in the query, even whitespace, run it again, and it might stop working ...
6
votes
1answer
360 views

Is there a way to DENY CRUD operations on connections from linked server?

I have a SQL Server instance, RPT1 (2008 R2), that was set up for "power users" to run their own queries. This server is linked to our production reporting server, PRD1 (SQL Server 2008 instance), ...
0
votes
1answer
457 views

Strange Sybase / SQL Server linked server issue

I have a sybase table which has a column note varchar(1000) null. The following T-SQL will get the following error if there is a not-null value in note. (sybase is the linked server to the Sybase ...
1
vote
0answers
182 views

Cannot Check if the Access Database Engine is Installed and Configured

All, I want to check if the Access Database Engine is installed and linked to SQL Server. On my development machine (x64-bit) the following queries both show the Access Engine to be avalible as a ...
2
votes
1answer
2k views

Linked servers: Transaction context in use by another session

I'm using linked servers to perform some queries in a distributed transaction. It doesn't work in a distributed transaction. I get the following error: Transaction context in use by another ...
1
vote
1answer
931 views

How do I delete rows from a table on a linked server

I need to delete rows from a table in several databases on several servers with the same schema. OPENROWSET() does not seem to be the answer. If I do this: SET @sqlStr = ' SELECT TOP 0 * FROM ...
4
votes
2answers
2k views

Linked servers login failure: Impersonate works, Username/password fails

I'm trying to set up a linked server between 2 instances of Sql Server 2008 R2. The login works perfectly when I select the impersonate option. However when I try to use the remote user/password ...
2
votes
1answer
594 views

Correct SQL Server linked server connection settings to MySQL that will allow inserts

I'm in linked server hell! I've created a linked server to a remote MySQL database. I'm able to query and do updates. However when I attempt an insert I get an error: "[MySQL][ODBC 5.1 ...
5
votes
4answers
2k views

Microsoft SQL server 2008 and linked servers

I'm designing a set of databases which might need to use each other's stored procedures or tables. The reason that I'm creating separate databases is that in the future I want to be able to move any ...
2
votes
1answer
627 views

ODBC Connection As Clustered Resource

First step in a long process of creating a Linked Server to an Informix database on a Sql 2008 (Win 2003 x64) cluster. I was wondering how to go about creating an ODBC connection as a clustered ...
1
vote
1answer
212 views

Is it possible in a view to reference a linked server implicitly rather than explicitly?

I'm using views and stored procedures that reference a linked server: SELECT Id, Name FROM [LinkedServer].Database.dbo.FooView I would like to hide the [LinkedServer].Database or at least the ...
1
vote
3answers
425 views

Find old linked servers on a restored copy of master/msdb db

We moved our dbs to a new server and the drives on the old server are still available, but the SQL service is offline and cannot be started. I want to find the linked servers that were registered on ...
4
votes
1answer
1k views

Performance difference between SQL Server Linked Server and direct query

A Management Studio query pane connected directly to a remote sql server executes and displays a simple table query of (SELECT * FROM table) in just under 2 seconds. The same Management Studio but ...
1
vote
1answer
400 views

Get statistics of open connection to linked servers

How can I get information about connections from my MS SQL 2008 server to linked servers (actually it's an Oracle db)? Things like number of currently open connections, and history of opened and ...
4
votes
3answers
185 views

how to copy data from SQL Server table to excel Spreadsheet thru Linked Servers

I try to copy data from a table in SQL Server 2005 into a excel spreadsheet. Since that sheet is linked to some external charts, so I have to overwrite the existing data with the updated data from SQL ...
1
vote
0answers
230 views

Update excel sheets from SQL Server 2005 linked servers

I use SQL Server linked servers to connect to Excel 2003 multiple tabs workbook. After connected, I have not problem to use select statement like: select * FROM OPENQUERY(TEST, 'select * from [fist ...
1
vote
1answer
900 views

SQL Server Linked Server Permissions

On a SQL Server 7 server, I have a linked server to a Sybase database server. select * from openquery(SYBASE_SERVER, 'select * from DBA.TESTTABLE') works fine if I'm logged in as an SA. If I try to ...
2
votes
1answer
336 views

Can't create linked server SQL Server 2005

I'm new to doing linked server and I have this error. "The linked server has been created but failed a connection" On the same virtual machine I have two SQL Server instances one 2000 ...
0
votes
2answers
5k views

How to add linked server SQL Server 2008 R2

I have two SQL Server 2008 located in different cities. I have physical access to one of them and I can exec SQL Server Management Studio there. For second server I have following parameters: ...
5
votes
3answers
10k views

SQL Server Linked Server performance: Why are remote queries so expensive?

I have two database servers, connected via Linked Servers. Both are SQL Server 2008R2 databases, and the linked server connection is made via a regular "SQL Server" link, using the current login's ...
0
votes
1answer
498 views

check if linked server table column exists

I have several access databases that I'm copying over to the sql server, connecting to as a linked server, and then pulling data from each night. I need to be able to identify if the current access ...
1
vote
1answer
1k views

Is there a syntax for accessing table names containing slashes?

I have a linked server registered in my SQL Server 2005 which accesses our SAP database (test system). It uses an ODBC driver provided by SAP, and is connected using the Microsoft OLEDB For ODBC ...
2
votes
2answers
2k views

Access Linked Server error “The provider did not give any information about the error.”

A little information. I'm running SQL SERVER 2008 R2 64bit. I have Microsoft.ACE.OLEDB.12.0 provider installed. On my production server I've setup a linked server to the access db using the provider ...
0
votes
2answers
2k views

The OLE DB provider “SQLNCLI” for linked server X reported a change in schema version between compile time X and run time X for table [tablename]

The below error starts happening once a week at the same time every week. The OLE DB provider "SQLNCLI" for linked server X reported a change in schema version between compile time X and run time X ...
2
votes
1answer
7k views

Local login impersonation not working with a linked server

I have created a linked server on my server using the following: exec sp_addlinkedserver @server=N'MyOldDB', @srvproduct=N'', @provider = N'SQLNCLI', @datasrc=N'MYSERVER', ...
1
vote
1answer
382 views

Which reporting method has better performance, using linked server or using lookup in SSRS?

I've been using the new lookup function in Reporting Services 2008 R2 when using different servers where I don't have the option of a linked server. However, the DBA just created the a link to that ...
2
votes
1answer
2k views

SQL Server 2000 to SQL Server 2008 linked server issue

Here's my scenario: I've got a linked server going from a SQL Server 2000 machine to a SQL Server 2008 machine. To aid in moving databases with a minimum of config changes, most of our connections ...
2
votes
2answers
1k views

Query data from multiple linked remote databases

Using SQL Server 2005 databases and SQL Server Management Studio 2008, I need to query a single value from each of n linked databases at a regular interval. The servers are physically remote and I can ...
2
votes
1answer
2k views

“Linked server does not contain table” error when using VFPOLEDB provider linked server

I am receiving the below error when attempting to run any queries via a linked server in SQL Server 2008 R2 using the Visual Fox Prox OLE DB Provider v9.0.0.3504. I am attempting this as I need to ...
3
votes
3answers
2k views

What's the difference between Linked Server solution and SSIS solution?

When I want to move data between two databases (e.g source: Oracle, destination: SQL Server), I think I have two options: Linked Server and SQL Server Integration Services. But is there any benefit ...