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.

Calling Oracle stored procedure with output parameter from SQL Server

I have an Oracle linked server in SQL Server 2008 R2. I need to execute Oracle stored procedures (with output parameter …

sql sql-server oracle stored-procedures linked-server
Retrieve >901 rows from SQL Server 2008 linked server to Active Directory

In SQL Server 2008 (version 10.0.4000) I have created a linked server to an Active Directory server. This query: select TOP 901 * from …

sql-server-2008 active-directory linked-server
Linking Server in SQL Server 2008 R2

Can anyone guide me around to linking a server to another in SQL Server 2008 R2? I am getting the following …

sql-server sql-server-2008 linked-server
How to reference a sql server with a backslash (\) in its name?

Givens: One SQL Server is named: DevServerA Another is named: DevServerB\2K5 Problem: From DevServerA, how can I write a …

sql-server sql-server-2005 tsql linked-server
I need to add a linked server to a MS Azure SQL Server

I have tried and tried, and can not get linked. I can connect to the server using SSMS, but can …

azure-sql-database server linked-server
Exec SP on Linked server and put that in temp table

Need some help on the below issue: Case 1 : stored procedure is on server 1 - call is from server1 declare @tempCountry …

sql-server stored-procedures linked-server
sql linked server join query

I am having issues running any query on joining a local DB with a DB from a linked server. My …

sql sql-server-2008 linked-server
How to list all tables & columns names of a linked-server database in SQL Server?

If it's a regular database, i can simply use this query to get a list of all table names and …

sql-server linked-server
Stored Procedure and populating a Temp table from a linked Stored Procedure with parameters

I have a Stored Procedure (SP) in which I pass in one value. In this SP, I am trying to …

sql-server stored-procedures linked-server
How to test linkedserver's connectivity in TSQL

I need to write a procedure to collect data from several remote servers, I use linkedservers and OPENQUERY to gather …

sql tsql connection linked-server openquery