Skip to main content
1,498 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
97 views

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 ...
Anya Hayes's user avatar
  • 1
0 votes
0 answers
144 views

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 ...
C Cost's user avatar
  • 1
0 votes
1 answer
190 views

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 ...
Nature and Code's user avatar
  • 3
0 votes
1 answer
198 views

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 ...
Enzo's user avatar
  • 3
-1 votes
1 answer
734 views

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 ...
markaaronky's user avatar
  • 1,305
-2 votes
1 answer
76 views

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 ...
a.Paryab's user avatar
  • 39
0 votes
1 answer
68 views

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 ...
Calvin's user avatar
  • 17
0 votes
1 answer
58 views

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 ...
Faraz Ahmed's user avatar
  • 1,627
-1 votes
1 answer
319 views

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 ...
ichachan's user avatar
  • 693
0 votes
1 answer
76 views

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 ...
Ben's user avatar
  • 1
0 votes
1 answer
163 views

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 ...
user3866578's user avatar
  • 3
0 votes
1 answer
159 views

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 ...
BinRip's user avatar
  • 43
0 votes
1 answer
38 views

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 ...
Mark Simmonds's user avatar
  • 21
0 votes
1 answer
142 views

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(( ...
Smeghead's user avatar
  • 185
0 votes
0 answers
61 views

Let me explain my situation: Server A: This is my SSRS (SQL Server Reporting Services) server, which hosts all users and source connections. SQL Server B: This server is used for query connections ...
Mujahid's user avatar
  • 47
0 votes
0 answers
47 views

I have a table in oracle server and I am trying to move the data in a SQL table, I created a linked server which works fine, when I try to move the data by specifying the where clause, it does not ...
Pierre Legrand's user avatar
  • 9
0 votes
1 answer
136 views

I have an insert statement basically something like this: insert into openquery(Test_LinkedServer, 'select a,b,c from my_ora_table') select a, b, c from my_dbo_table; ...
Oguen's user avatar
  • 519
0 votes
1 answer
256 views

I have a requirement to link to an Oracle server in the cloud through a linked server in Sql Server. I have created a stored procedure to execute a generic PL/SQL script that returns an IEnumerable<...
Timothy Dooling's user avatar
  • 522
1 vote
0 answers
236 views

I see that with snowflake ODBC driver you can specify the authenticator as oauth and provide token for authZ. But I am trying to figure out when using the ODBC driver from snowflake for SQL linked ...
Javi's user avatar
  • 11
0 votes
1 answer
341 views

I am using SQL Server v18.10, and try to create a variable for dynamic date and pass it into linked server OPENQUERY. I able to display the date result in SQL but not in linked server. I followed the ...
lee sheng yap's user avatar
  • 1
1 vote
0 answers
93 views

I'm trying to update a target server using the Schema Compare feature in Visual Studio 2019. Upon checking the sys.servers table, I can see the linked server and confirmed that I can run queries ...
DBAle's user avatar
  • 11
3 votes
1 answer
4k views

My team has read-only access to a remote PostgreSQL database - which we query remotely from our local SQL Server instance using a linked server connection. We cannot modify the remote Server's ...
Alain's user avatar
  • 27.4k
0 votes
1 answer
80 views

I'm working on a project where I need to connect to a Cosmos DB using a Linked Server connection in SSMS. As I make the connection, I need to use the ODBC Schema Editor to map the data. Within the ...
alcor8's user avatar
  • 383
0 votes
0 answers
126 views

I have a snowflake DB that I want to copy into a SQL Server database. The .NET connector in C# is too slow to work with so I thought about schedule a stored procedure that will copy a part of the ...
dadou's user avatar
  • 47
0 votes
0 answers
163 views

I have set up a linked server connection from my on-premise to Azure called AZURE. When I run the following code, it errors out: DECLARE @DynamicSQL NVARCHAR(MAX)=' MERGE [AZURE].[Test].[dbo].[...
user avatar
0 votes
0 answers
64 views

Question summarized: How do I get Pervasive SQL 15.2 as a Linked Server into SQL Server 2022 like we did with 9.7 into 2000? Background and details: We have an ERP system that's using a Btrieve ...
darkeldar's user avatar
  • 9
0 votes
0 answers
36 views

I am having an issue troubleshooting what is wrong with this linked server that I set up in SQL. This is what my setup looks like in SSMS I am able to query things successfully inside SSMS like this ...
joeb's user avatar
  • 887
0 votes
1 answer
409 views

Update trigger doesn't work while using SQL Server linked server. I created a linked server on my local SQL Server. I can query this linked server (SELECT, UPDATE, INSERT etc.) from my local machine. ...
Farhad Aliyev's user avatar
  • 19
0 votes
2 answers
181 views

I am trying to use dplyr to pull data from a table on a linked SQL Server. I am able to connect and run queries using the dbGetQuery method as long as I (1) provide the fully qualified path ([server ...
Kourosh Alizadeh - CDPHE He Hi's user avatar
  • 1
0 votes
0 answers
513 views

We had SQL Server 2012 and MySQL Server 8.0.35 on ubuntu. We migrated the SQL Server to 2022 (Windows Server 2022). MySQL server still the same. Now when I use linked Server with the MySQL server most ...
halliballi's user avatar
  • 130
1 vote
0 answers
189 views

Our SQL Server 2019 (Server A) is configured to use linked servers with SQL Server 2019 (Server B). Kerberos Authentication is enabled and SPNs are configured correctly. All the accounts needed are ...
sqllover2020's user avatar
  • 21
0 votes
1 answer
207 views

I created a linkedserver from SQL Server 2016 to Filemaker database on another server. ODBC driver version in 19.xx. Using the ODBC driver and DSN, I can see the data from the Filemaker database using ...
Hijesh V L's user avatar
  • 279
0 votes
0 answers
102 views

I have Linked server from PostgreSQL 12 to my SSMS and trying to join two PostgreSQL tables and insert the result to my table with the stored procedure. The problem I have is when adding a WHERE ...
Pawel G's user avatar
  • 47
0 votes
1 answer
339 views

I have a similar requirement but the other way. I.e I have a table in an Azure SQL database, which we need to copy data from the Azure SQL database to an on-premise SQL Server database. The table ...
vikranth reddy's user avatar
  • 3
0 votes
2 answers
112 views

I have a Azure SQL online SQL-database. How can I create a linked server to a DB2 server with a VPN (Fortigate). I have checked some tutorials, but my SSMS does not have a folder "linked Servers&...
Lukas Fürst's user avatar
  • 153
1 vote
1 answer
152 views

Setup: AzureVM. Azure VM running SQL Server 2022 LS_CSV: Linked Server to Synapse SQL Endpoint database, which itself has Views to CSV files in Spark LS_Delta: Linked Server to Synapse SQL Endpoint ...
Pingyao's user avatar
  • 109
0 votes
2 answers
884 views

On my SQL Server instance, I have about 30-40 stored procedures. In those stored procedures, sometimes I call a table from a linked server something like. Select * From Picktickets P Left Join [JMNYC-...
user7959439's user avatar
  • 173
0 votes
0 answers
78 views

I am trying to validate if my linked server is up: CREATE PROCEDURE [dbo].[GET_Validate_LinkedServer] @LinkedServer NVARCHAR(50), @Status BIT = NULL OUTPUT AS BEGIN SET NOCOUNT ON; ...
Josue Barrios's user avatar
  • 502
0 votes
1 answer
184 views

How do I create a linked server between DWH SQL Server (which is in a service providers environment) and MS Azure. What type of settings must I make sure is on Azure and what is the string that I ...
Reez's user avatar
  • 13
0 votes
0 answers
67 views

I have a linked server that I am able to run views on. I have one view in particular that when I run it, the wrong data is returned. When I run sp_helptext on the view to get the definition, the ...
TheOriginalCole's user avatar
  • 97
1 vote
1 answer
1k views

I have SQL Server Managed Instance. Now I want to get data from on-premises SQL Server to SQL Server Managed instance through linked server on a daily basis. The on-premises SQL Server has only ...
Narendra's user avatar
  • 44
0 votes
1 answer
89 views

I want to insert a new rows into database in MySQL server from SQL Server Management Studio. To make it possible I've created a linked server in SMSS with this guide: https://www.sqlshack.com/how-to-...
Signor's user avatar
  • 1
0 votes
0 answers
126 views

In a stored procedure, I have a few With clauses, of a query executed at linked server A: DECLARE @myQuery VARCHAR(MAX) SET @myQuery = 'SELECT * FROM (WITH A AS (Select ... from ...), B AS (...
Henry's user avatar
  • 1
0 votes
0 answers
119 views

I have a SQL Server linked server called [HJNSDATAENG.DW]. I have created a SSAS multidimensional project called rh_dw. I want to set as my SSAS project's data source the database [warehouse] located ...
hermann joel's user avatar
  • 65
0 votes
1 answer
1k views

I need some help in configuring an SQL Server csv linked server. I already have an Excel linked server working without any problems, but each time I try to connect to my csv, I get varying error ...
Steve Martin's user avatar
  • 99
0 votes
0 answers
3k views

In my SQL Server version 15.0.4312.2, I linked another SQL Server same version. The servers are in the same Active Directory Domain. Unfortunately, I get a lot of errors because apparently one server ...
Enrico's user avatar
  • 6,902
0 votes
1 answer
409 views

An error occurred while preparing the query SELECT SUBSTRING(UGB,1,9) as EntityCode, SUBSTRING(FUNCIONARIO/CREDOR DESCONTADO,1,9) as NRCId, SUBSTRING(FUNCIONARIO/CREDOR DESCONTADO,11,75) as CustName, ...
Sugi Joshuva's user avatar
  • 1
0 votes
2 answers
376 views

How to execute SQL script when the linked server connects success. this script from other website. but i didn't know how to insert query below the script when connection success. ----------------------...
Edwardk's user avatar
  • 3
1 vote
0 answers
123 views

We have a stored procedure running on SQL Server that exchanges data with an Oracle table, through a linked server, the versions of both products are at the end of this post. In our stored procedure, ...
Agostinho's user avatar
  • 21
0 votes
1 answer
74 views

I am trying to execute the below - DECLARE @SQL nvarchar(max), @LinkServer nvarchar(200), @min INT=1, @max INT drop table if exists #clients; create table #clients (Id int identity(1,1), ClientName ...
Dgstah's user avatar
  • 191

1
2 3 4 5
…
30