Question : Last week we began having an issue with a Linked Server to an Oracle database on one of […]
Tag: linked-server
SQL Server 2012 – Disable Job On Linked Server
Question : I have a job on server B, which is linked to server A. Is it possible to disable […]
Joining table from Linked Server is very slow
Question : I have a production SQL server and a linked server (Azure SQL Database) I join two tables to […]
Pivot rows into multiple columns
Question : I have a SQL Server instance that has a linked server to an Oracle server. There is a […]
Create LINKED SERVER to MYSQL using SSH
Question : Is there any way to create a MS SQL Server Linked Server to connect to MySQL through SSH? […]
ETL Issue failing with Timeout error
Question : We have a ETL job which is running each day at 02:00 AM. Until last week the Job […]
Could not complete cursor operation because the table schema changed after the cursor was declared
Question : I get this error message occasionally when I execute a stored procedure that pulls information from multiple linked […]
Unable to update MySQL table from linked server on SQL Server 2014
Question : I’m using SQL Server 2014, with a linked server to a MySQL database on AWS. I need to […]
Source code of View of Linked server sp_HelpText
Question : How to use sp_helptext for view on the linked server ? Answer : There is an answer on […]
Linked server only works if I am on the machine itself. I can’t use it from my local computer. what is missing?
Question : I have a few queries that I use to monitor log shipping. Sometimes I want to run those […]