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
0 answers

Pass sp_linkedserver parameters from SSRS into SQL Server stored procedure

I'am trying to combine SQL and MDX data on SQL Server Reporting Services. I found a solution about the sp_addlinkedserver. Exec sp_addlinkserver @server = 'localhost' @srvproduct = '' @provider = 'MSOLAP' @datasrc =…
ggarcia
  • 47
  • 1
  • 10
0
votes
0 answers

Linq-to-SQL transaction breaking linked server query

I have a simple application that uses Linq-to-SQL to retrieve and update data. On my DataContext I have a procedure called GET_DATA that reads data from a non-SQL Server data source using a linked server. I use the data read to update a few tables…
Diego
  • 34,802
  • 21
  • 91
  • 134
0
votes
1 answer

How do I register IBM.Data.DB2.iSeries as a linked server provider in SQLServer?

I have connected to a DB2 database on our AS400 through SQL Server 2005 (linked server) using the IBMDA400 (OLEDB) provider. However, I recently discovered that I can connect my .Net apps using the IBM.Data.DB2.iSeries.dll provider so I would like…
user134363
0
votes
1 answer

SQL query to linked index server does not work w wildcards

this statement I use in a sproc (where the search phrase 'reiseportal*' is a parameter) does not work with a wildcard, as I recognized: DECLARE @strSQL NVARCHAR(MAX) SELECT @strSQL= 'SELECT FileName, path, size, vpath from…
Michael Niemand
  • 1,578
  • 3
  • 23
  • 39
0
votes
1 answer

How to connect to remote sql server from SQL Server 2008

I am using SQL Server 2008. I have to access our company portal database which is maintained by a third party. They had given me login details. Please explain how to connect to their database. I can't post the link here
Pavi
  • 335
  • 2
  • 3
  • 20
0
votes
1 answer

SQL Server OpenQuery to Oracle schema with $

I am trying to connect from SQL Server 2008 R2 into an Oracle Linked Server, but the Oracle Schema has a $ symbol in it. Unfortunately, I can't change the schema name, but it appears to be causing me an issue when trying to extract information…
G-Man
  • 184
  • 2
  • 14
0
votes
3 answers

With clause does not work linked server

I've been connecting to an oracle 10g server using ms sql servers linked server feature and for some reason i am unable to use the with clause. Does this clause only work in in the pl/sql console or is there something i can do to make it work with…
zSynopsis
  • 4,854
  • 21
  • 69
  • 106
0
votes
1 answer

Failing to delete record from linked server

I've spent the past two days searching everywhere for a solution to my problem but without any luck. I have this query that deletes record from a remote server: delete from OPENROWSET('SQLNCLI',…
Moshe Derri
  • 206
  • 2
  • 11
0
votes
2 answers

how to get test data from production to dev with least performance impact on prod?

Frequently we need to get some test data from our production sql server 2008 (non r2 enterprise) to our development sql server 2008 r2. Obviously when we do this data extract we want to have minimum performance impact on the production box. Which…
Gullu
  • 3,477
  • 7
  • 43
  • 70
0
votes
3 answers

Stored Procedure: Linked server login failure

I'm getting "Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." from when trying to execute the code below. I've change all of the critical information, but you should get the idea. Are some of my parameter…
Tony Evans
  • 163
  • 2
  • 10
0
votes
1 answer

In search of a better solution to querying a remote Access database with VB.net

Please tell me there is a better solution to querying a remote Access database! We are currently using this because thus far we have failed at hooking up a sp_linkedserver. I feel like it's a terrible hack and want to be done with this whole network…
user114518
0
votes
1 answer

How can we overcome double authentication for sp_linkedserver? (Already set up through DB authentication)

So we've set up a sp_linkedserver on SQL Server to connect to a remote Access database. Assume the path to this database is W:/breakfast/pancakes/secretPancakes/pancakeDB.accdb We know the username and password to the actual database Password:…
user114518
0
votes
1 answer

Issue calling a stored procedure with one input parameter on a linked server on my local SQL Server

I am setting up a SQL Server database and have been given access to call a stored procedure in a remote server to help populate some tables. I created a linked server as SSIS in Visual Studio 2008 and SQL Server Management Studio 2008 seem to not…
user1417337
  • 75
  • 1
  • 4
  • 11
0
votes
2 answers

Compressing Data Within a Query

Suppose you have two linked servers called Local and Remote respectively. Is there a syntax that compresses (and uncompresses) the data required to be sent from the Local to Remote (or vice versa). For example, if I am updating my Local database…
super9
  • 29,181
  • 39
  • 119
  • 172
0
votes
2 answers

Performance Issue with Distributed Queries

the code below works fine but it takes an absolute age to run. How can I speed this up? Background: I have linked my local server to my remote server. From my local server, I need to insert data from the remote server into my local server and then…
super9
  • 29,181
  • 39
  • 119
  • 172
1 2 3
…
99 100