Linked server allows operation to multiple server as one query.
2
votes
3answers
99 views
How can I query data from a linked server, and pass it parameters to filter by?
I have a really big query that needs to be run on multiple databases, and the results appended to a temp table and returned.
The basic syntax looks something like this:
INSERT INTO #tmpTable (Id, ...
1
vote
2answers
187 views
SQL Server update query on linked server causing remote scan
I have a SQL Server 2012 setup as a linked server on a SQL Server 2008 server.
The following queries executes in less than 1 second:
SELECT kg.IdGarment
FROM Products p
INNER JOIN ...
1
vote
1answer
116 views
MySQL - run SELECT statement on another server without defining the table structure
In MySQL I can query information on another server using federated tables, as long as I've defined the same table structure locally.
In MS SQL Server, however, I can run any SQL statement against a ...
3
votes
0answers
660 views
“Prelogin failure” when attempting to run stored procedure across linked server
I'm getting the below error when attempting to run a stored proc across a linked server that is going from Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) to Microsoft SQL Server 2008 (SP2) - ...
2
votes
0answers
29 views
Update Sql Server from Mysql
We have a website that stores form data in a web hosted MySQL database. Whenever form data is entered into the MySQL server tables I need update all necessary tables on our local SQL Server database.
...
2
votes
0answers
251 views
Linked server issue
I made a linked server between two sql server instances. The remote one I have very little control over. When I try a query I get this:
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for ...
1
vote
0answers
60 views
sp_testlinkedserver taking long time to time-out
I'm using the following code to check if a linked server is available before running queries on it:
declare @srvr nvarchar(128), @retval int;
set @srvr = 'my_linked_srvr';
begin try
exec @retval ...
1
vote
0answers
58 views
What permissions are required to view the contents of a catalog on a remote server?
I defined a linked server from a SQL Server box to a MySQL box. I went through a very detailed set of instructions and steps, everything works like a charm when I am logged in.
The linked server ...
1
vote
0answers
110 views
Cannot Check if the Access Database Engine is Installed and Configured
All, I want to check if the Access Database Engine is installed and linked to SQL Server. On my development machine (x64-bit) the following queries both show the Access Engine to be avalible as a ...
1
vote
0answers
161 views
Update excel sheets from SQL Server 2005 linked servers
I use SQL Server linked servers to connect to Excel 2003 multiple tabs workbook. After connected, I have not problem to use select statement like:
select * FROM OPENQUERY(TEST, 'select * from [fist ...
0
votes
0answers
27 views
EXECUTE AS over Linked Servers
I have a front end that logs into the DB as "logInA", and only has permission to "schemaA" stored procs, which use EXECUTE AS "logInB", (I have also tried EXECUTE AS 'DBO'), to handle all the business ...
0
votes
0answers
87 views
SQL Server link to linked server
My client has a Visual FoxPro database that needs to co-mingle with SQL Server data (SELECT only, no updates or deletes).
After quite a bit of searching I found the VFP OLEDB provider doesn't work ...
