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
4
votes
6 answers

Run a Query from Linked Server (Oracle) in SQL Server2008 R2

I have the linked server set up in SQL Server 2008. But I could not run any query against the linked server. I tried to run this simple command but it's not working SELECT * FROM MYSERVER..ALANH.TEMP_UPDATE1 This is the error I got when I run…
TTCG
  • 8,805
  • 31
  • 93
  • 141
4
votes
0 answers

SQL Server Agent Job stops SSIS Step with "unexpected error" and without any error informations

I am dealing with my problem on some Windows Server 2019 (Core) with one running SQL Server 2019 CU4 instance each. What we try to do We are currently building a data warehouse with distributed databases. The individual layers of the DWH are…
user_AL
  • 66
  • 7
4
votes
1 answer

Where is the bottleneck / what are the gotchas when selecting records from a remote (linked) SQL server?

I'm in a satellite office that needs to pull some data from our main office for display on our intranet. We use MS SQL Server in both locations and we're planning to create a linked server in our satellite office pointing to the main office. The…
Ken Pespisa
  • 21,989
  • 3
  • 55
  • 63
4
votes
2 answers

SSIS performance vs OpenQuery with Linked Server from SQL Server to Oracle

We have a linked server (OraOLEDB.Oracle) defined in the SQL Server environment. Oracle 12c, SQL Server 2016. There is also an Oracle client (64 bit) installed on SQL Server. When retrieving data from Oracle (a simple query, getting all columns from…
Alex V
  • 305
  • 2
  • 7
4
votes
5 answers

SQL 2005 Linked Server Query Periodically Failing

We have a database running on SQL 2005. One of the store procedure looks up a user's email address from Active Directory using a linked server. The call to the linked server occurs in a database function. I'm able to call is successfully from my…
anschoewe
  • 1,089
  • 1
  • 14
  • 34
4
votes
4 answers

How to create linked server on remote server to local PC

How to add linked server establishing connection from remote SQL Server linking to local instance of SQL Server Express? By local I mean the PC I use with SQL Server Express instance and by remote I mean server I connect to with SSMS. Mostly on the…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
4
votes
3 answers

create linked server in azure sql database

Want to create linked server in azure sql. I want to use local DB views in sql azure using linked server. Is it possible or is there any alternate way. All suggestions are welcome.
JOMON
  • 41
  • 1
  • 2
4
votes
4 answers

linked server problem at sql server while connecting to oracle dbms

I have created a linked-server definition according to the article at : http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/ My aim is to transfer rows to tables at Oracle 11gR2. After creating linked server, whenever I try…
kayhan yüksel
  • 378
  • 2
  • 9
  • 24
4
votes
0 answers

MySql ODBC 5.3 (a) Driver optional feature not supported while inserting from trigger

I have one MySQL Server and SQL Server 2016 and have access the MySQL Database objects in SQL Server using a linked server. When executing the OPENQUERY of DML it was working good but when executing those query's from trigger its show's the…
Deepak Gupta
  • 73
  • 1
  • 5
4
votes
1 answer

Unable to enlist in the transaction

I have problem: I have 1 sql server already setup SQL Server 2014 Express in Windows and 1 Oracle Database server 11g in Linux in another server. Now i want to insert data from SQL server to Oracle database through link server. I am able to make…
Andi
  • 41
  • 1
  • 2
4
votes
1 answer

Connect TO Sql Server From MySQL

How can I connect to a SQL Server Database from a MySQL Server? I need to use the MySQL as a proxy DB (querying all the SQL servers and MySQL connected to it). I need a functionality sort of "linked server" one on SQL server.
Andy
  • 41
  • 1
  • 2
4
votes
1 answer

SQL Server Linked Server query returns empty rows

I use SQL Server 2014. I have setup a linked server via ODBC to a legacy database system. When I run this query: select * from openquery([MyLink], 'select Ref, FxRate from where Ref=155003') I get the result with the correct number of…
user2966852
  • 83
  • 1
  • 8
4
votes
1 answer

Update sys.servers after renaming SQL Server Host

I'm about to upgrade my SQL Server 2012 instance to SQL Server 2014. I've cloned the host Windows VM and renamed it from foo-2012 to foo-2014. On restart, SQL Server instance noticed this as updated its own name, so I can now log into it as…
Brondahl
  • 7,402
  • 5
  • 45
  • 74
4
votes
2 answers

Selecting a column with period in the column name SQL Server

I am linked to a Proficy Historian that allows periods in the column names. Because the data is stored in a non DBMS format I can not use openquery to get the data because there is no set schema to the tables. So I must use four part name syntax…
efbenson
  • 189
  • 1
  • 9
4
votes
1 answer

How to Insert into remote table using Linked server withint Transaction?

My Linked server is setup correctly , I am able to perform below query. INSERT INTO [RemoteServer].[Table] SELECT * FROM [LocalServer].[Table] However when I do the same thing within transaction BEGIN TRAN INSERT INTO [RemoteServer].[Table] …
Zeus
  • 3,091
  • 6
  • 47
  • 60
1 2 3
…
99 100