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.

How to backup linked servers with SQL Server?

I want to backup/restore my data which is distributed in some linked servers, which are connected or linked in …

sql-server linked-server database-backups database-restore
Creating a Linked Server and Database Alias

I have two servers Server1 and Server2 On both servers i have a Database called QAI is there a way …

sql sql-server linked-server
SQL Server Linked Server query running out of memory

I have a DBF file on a network share that I'm trying to select into a SQL Server table. This …

sql-server foxpro linked-server
What are the drawbacks of using linked servers in SQL Server?

Are there any huge performance issues or security concerns? Using SQL Server 2005 and higher

sql-server linked-server
Getting an Error on inserting data when using Linked Server Queries

UPDATE : The issue was col1 was hiereachyid type and even a select didnt work for it. Hi all, I am …

sql-server insert linked-server
Execute query to linked server as another user

I'd like to execute a query which uses linked server as a specific user. However, not even a simple example …

sql-server impersonation linked-server
INNER JOIN on Linked Server Table much slower than Sub-Query

I came across this very odd situation, and i thought i would throw it up to the crowd to find …

sql sql-server linked-server msdtc
Linked server to Intersystems Cache database from MS SQL Server 2005 Browse Catalog

I'm trying to create a linked server in MS SQL Server 2005, pointing to an Intersystem Cache database via ODBC. Below …

sql linked-server intersystems-cache intersystems
Can you have a Foreign Key onto a View of a Linked Server table in SQLServer 2k5?

I have a SQLServer with a linked server onto another database somewhere else. I have created a view on that …

sql sql-server sql-server-2005 foreign-keys linked-server
SQL Server Error: maximum number of prefixes. The maximum is 3. with join syntax

Trying to run a cross-server update: UPDATE ASILIVE.CustomerManagementSystem.dbo.Sessions SET ASILIVE.CustomerManagementSystem.dbo.Sessions.VarianceAmount=Variances.VarianceAmount FROM …

sql-server sql-server-2000 linked-server