Top "Linked-server" questions

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

"ASP.NET" error: Access to the remote server is denied because no login-mapping exists

I'm able to execute a stored procedure which queries a Linked Server directly, but when I call the same sproc …

asp.net sql-server sql-server-2008 linked-server
catastrophic failure trying to select from linked server

I have created a linked oledb/odbc connection to Pervasive SQL from SQL SERVER 2012: USE [master] GO /****** Object: LinkedServer [KSLAP208] …

sql sql-server tsql sql-server-2012 linked-server
Login failed when querying linked server

I am trying to create a linked server in SQL Server: --Create the link to server "uranium" EXEC master.dbo.…

sql-server linked-server
Can I join data from 2 different DB2 databases? (Like SQL Server linked databases)

I'm enhancing an existing java application. There is data in 2 different DB2 databases. The app already gets data from 2 different …

sql db2 linked-server
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "progress"

I'm trying to select some data from a Progress Database using an openquery on SQL Server 2008 R2, but I'm getting …

sql-server-2008 linked-server openedge progress-db
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 …

sql-server database oracle linked-server
Linked Server Insert-Select Performance

Assume that I have a table on my local which is Local_Table and I have another server and another …

sql-server sql-server-2008 linked-server
OPENROWSET or OPENDATASOURCE Example to get Data from .xlsx or .csv file on file system of Remote Server

There are plenty of examples around showing how to use OPENROWSET and OPENDATASOURCE to open queries against tables on remote …

sql-server excel csv linked-server openrowset
sql server linked server to oracle returns no data found when data exists

I have a linked server setup in SQL Server to hit an Oracle database. I have a query in SQL …

sql-server linked-server ora-01403
View linked server dependencies sql server 2008

Does any know how / if it is possible to view all tables/views/stored procedures that depend on a linked …

sql-server dependencies linked-server