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.

SQL Server spatial and linked servers

I have a SQL Server instance that I've added a linked server to another SQL instance. The table I'm accessing …

sql-server sql-server-2008 spatial linked-server
error when insert into linked server

I want to insert some data on the local server into a remote server, and used the following sql: select * …

sql-server insert linked-server
Linked server setup between SQL Server Express and SQL Server

Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (…

sql-server linked-server sql-server-2005-express
SQL Server 2012: Add a linked server to PostgreSQL

I try to connect a PostgreSQL to SQL Server 2012 server as linked server I found some advices on different forum …

sql sql-server postgresql sql-server-2012 linked-server
Is it possible to create a temp table on a linked server?

I'm doing some fairly complex queries against a remote linked server, and it would be useful to be able to …

sql sql-server linked-server temp-tables
Linked Server In SQL Server Express

I am developing an app where i have a local database in SQL Server Express. During work in local database, …

sql-server database sql-server-express linked-server
Escape single quote in openquery using dynamic query

I need to retrieve data from a linked server using a parameter, @PickedDate for example. The query works fine if …

sql-server dynamic-sql linked-server openquery
Connect to IBM i server from Sql Server 2008 R2

I have a big deal: I have to connect (I just want to read data, not to write) to my …

sql-server database-connection oledb ibm-midrange linked-server
Sharing data between SQL databases

I'm trying to solve a problem, that for once, I didn't create. I work in an environment with many web …

sql-server database linked-server data-exchange
Best way to get identity of inserted row in Linked server?

I am inserting record in a remote Sql Server using Linked server, Now I wanna get the id of inserted …

sql-server sql-server-2000 linked-server