1,501 questions
0
votes
0
answers
85
views
SSIS package performance jumps randomly with a query between two linked SQL Servers
I have a SSIS package deployed that performs a delete-insert operation on a small dataset querying through a linked connection to another SQL Server. Normally this operation is measured in seconds to ...
0
votes
1
answer
79
views
Why OPENQUERY fails with multiple CTEs with a where clause in some cases but not others
I have a query that contains two CTEs, one based on a linked Oracle server (from a SQL Server) that fails. I can fix it by doing any of the following: add a select limit (e.g. TOP 1000) to the SELECT ...
0
votes
0
answers
110
views
Saved Remote Password on a SQL Server Linked Server Becomes Invalid After a Server Restart
I have a SQL Server instance on AWS RDS with a Linked Server newly set up for replicating records from one database to another. This is working as expected. Today, the database was bounced as part of ...
- 1
0
votes
1
answer
169
views
How do I get a list of stored procedures from a linked server?
I am trying to do a backup of all stored procedures and tables from one database server to another. I want to get a list of stored procedures and tables that exist in the destination database so I can ...
0
votes
1
answer
147
views
Possible ways of updating the catalog of an already created Linked server
Reason for change
I have a main Staging server with multiple linked server's setup.
Each one of these Linked Servers have their own DB on the main Staging Server.
I have an SP that extracts data from ...
- 3
-1
votes
1
answer
579
views
Cannot get Linked Servers to work with MS SQL Server developer edition
This may seem like an overly verbose post but I appreciate being given all the details when asked a question, so I am doing the same thing here:
I have a situation where I'm running SQL Server Dev ...
- 1,305
-2
votes
1
answer
69
views
Getting SQL Server version of linked server
I have many linked servers in my SQL Server.
A need has arisen that getting SQL Server version of these linked servers in a script.
I find following command that return SQL Server version of current ...
- 39
0
votes
1
answer
61
views
Reference Linked Server in LocalDB stored procedure [duplicate]
I am writing a system that reads from a remote server and read/write to a local server. I am at the point where I now have to query data from both the remote server and my local server together (for ...
- 17
0
votes
1
answer
54
views
Use MySQL linked server with dynamic db name
I have a table category, which exists in both test and prod db. Whenever I have to get data from MySQL I have to write test or prod in db like below, as openquery doesn't support dynamic query.
SELECT ...
- 1,627
-1
votes
1
answer
290
views
Running Remote Function with Parameters in Linked Server
I have a SQL function that adds a number of business days into a specific date.
The function is running ok in the local database server.
However I'm having problem running the function from linked ...
- 693
0
votes
1
answer
72
views
Slow linked server (SQL Server to Oracle)
I need to move data from an Oracle database to SQL Server.
If I run this very simple directly on the database, I get my results in < 1 second (returns 30K out of 250m rows):
select *
From my_table ...
- 1
0
votes
1
answer
159
views
Error copying data from SQL Server to Redshift via a linked server connection
We have local SQL Server data that we would like to sync to Redshift nightly. I can write individual values to the Redshift server, but can not can do a standard insert of data from a local table
...
0
votes
1
answer
147
views
Linkedserver connection to MySQL database with ODBC driver connection issue
I have setup SQL Server 2016 linkedserver to connect to MySQL 8 instance and created stored procedure that insert data from SQL Server database to MySQL database using open query, it works fine when I ...
- 43
0
votes
1
answer
31
views
Configure an INSERT INTO query with multiple UNIONs across multiple databases and multiple servers
I have seen examples of INSERT queries that pull date from tables in multiple databases or multiple servers but I have not been successful in putting all of it together.
I have a query that uses ...
0
votes
1
answer
129
views
STUFF XML with openquery is matching on values that should've been filtered out in the where clause?
I typically use STUFF and XML to concatenate multiple values where I'm expecting one distinct row, e.g.
Category
Product
Fruit
Apple
Food
Apple
select distinct
t1.Product
, Categories = STUFF((
...
- 185