Stack Overflow
Stack Overflow

Questions tagged [linked-server]

The SQL Server "linked server" feature makes it possible to execute commands, such as a SELECT statement, on a remote server.

Use this tag for any questions related to SQL Server's linked server feature.

A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers. Linked servers offer the following advantages:

  • Remote server access.
  • The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.
  • The ability to address diverse data sources similarly.

An OLE DB provider is required for this functionality to work.

See MSDN for more information.

1493 questions
0
votes
1 answer

Joinning SQL Server table with *.mdb file

I'm trying to joinning SQLServer 2008 R2 tables with msaccess table (*.mdb). I already tried "OPENDATASOURCE" and "Linked Server", but no one of them is work correctly. in example, I've got the following message: OLE DB provider…
stkertix
  • 81
  • 1
  • 10
0
votes
1 answer

Does MSSQL always copy tables when using Linked Server

After googling and looking into the MS documenation (http://msdn.microsoft.com/en-us/library/ms188279.aspx) on linked servers I still couldn't get a clear answer to the following question. I'm thinking about linking 2 SQL Servers so I can create a…
Rob
  • 2,466
  • 3
  • 22
  • 40
0
votes
1 answer

MSSQL stored procedure with sybase linked server getting recompiled for each execution

I have a stored procedure in MS SQL Server that uses a Sybase linked server. Each time the stored procedure is executed it runs for a long time and looks like it is recompiling before execution. Any idea how to stop this recompilation?
user2296151
  • 1
0
votes
2 answers

SQL Server 2008 R2 JOB Step Linked Server Login Failed

I need to transfer a table daily. Table name is changing every day, so i should use script to get the tableName. There is a job step which transfers data from sourceTable to destinationTable created by using T-SQL query. sourceTable and…
Ismail Yavuz
  • 6,727
  • 6
  • 29
  • 50
0
votes
0 answers

Stored procedure with referenced linkedserver

I am fighting with stored procedure with referenced linkedserver. Linked server is accesible over internet via port forwarding - so no VPN, LAN. Servers are on both sides MS SQL SERVER 2008 EE v. 10.0.5512 Configurations Linked server, DTC: cannot…
MartinM
  • 61
  • 1
  • 2
  • 6
0
votes
2 answers

Link Server Optimization Help

I have this code in a trigger. if isnull(@d_email,'') <> isnull(@i_email,'') begin update server2.database2.dbo.Table2 set email = @i_email, where user_id = (select user_id from server2.database2.dbo.Table1 where login = @login) end I would…
Sandy DeLeon
  • 622
  • 6
  • 17
0
votes
1 answer

Table locking behaviour of SQL Server 2005 while extracting data from Oracle

I am trying to understand a SQL Server behaviour in below case. I am fetching around half million rows from Oracle into a SQL Server 2005 database using linked server created in SQL Server. I am using around 50 odd columns for a Insert Into select…
Charudatta
  • 45
  • 6
0
votes
1 answer

SQL Server - Oracle Linked Server with join

Hare is the scenario: Main DB Server: SQL Server 2008 R2 with a Linked Server to Oracle 11g. I have a Stored Procedure that make a query like: Select t1.a, t1.b, t2.c, t3.d From LocalTable a inner join LinkedServerName..Schema.Tableb b on a.aNumber=…
HiperiX
  • 395
  • 5
  • 19
0
votes
1 answer

Creating a linked server from SQL Server X64 to text and Excel using the Access driver

We are now in progress of moving all our production databases from a SQL Server 2005 32 bit instance to a brand new SQL Server 2012 64 bit instance. one of the main hardships that our developers still suffer is Linked Servers. We have a lot of…
Eli Ekstein
  • 466
  • 8
  • 19
0
votes
1 answer

DB Alias on Sql Server 2008

I need to run a migration from my server1 to server2, in both servers have the same DB schema Server1: DB1.dbo... All tables DB2.dbo... All tables Server2: DB1.dbo... All tables DB2.dbo... All tables I need connect from server1 to server2,…
Mariano G
  • 255
  • 4
  • 14
0
votes
1 answer

Sql Server 2008 - Catch execution error thrown by a stored proc running on a linked server

To give some background detail, let's say there's a 'Person' table and a stored proc 'PersonPerformance' that returns the performance of a Person given a PersonId. Both of these objects reside on a linked sql server 2000 instance. My goal is to run…
Brandon
  • 1,566
  • 2
  • 14
  • 22
0
votes
1 answer

Linked Server from x64 sql server to x64 Oracle

I am having a sql server 2005 x64 SP2 server (9.00.5069.00 (X64)) on Windows 2003 server (Service Pack 2) I would like to create a linked server from this server to an Oracle server which is running in x64 bit machine. I do have x86 Oracle client…
user007
  • 1,504
  • 2
  • 18
  • 51
0
votes
1 answer

SQL Server 2005 DB2 Linked Server Error When Inserting Result Set into a Temp Table

We have a linked Server against DB2 on SQL Server 2005. When we tried putting a simple query result set from the linked sever into a temp table return this error. OLE DB provider "MSDASQL" for linked server "SOMEDSN" returned message "[IBM][CLI…
user2008421
  • 41
  • 4
0
votes
1 answer

Failed scheduling a task involving linked servers with SQL Server Agent

How can I make a scheduled task work? I want to schedule a task that runs a query nightly. The query parses correctly and essentially grabs data from the SQL Server 2005 database on server2 and inserts the data into a table in a database on…
user2093192
  • 77
  • 1
  • 7
0
votes
1 answer

SQL Server Linked Server with Oracle - Issue: Select * x Select Columns

I have a performance problem with the OPENQUERY on SQL SERVER 2008 R2: When I run: select * from openquery([LINKEDSERVER],' SELECT COLUMN1,COLUMN2,COLUMN3...(45 columns at all) FROM ORACLE_TABLE …
user2092790
  • 1
1 2 3
…
99 100