linked-server Examples and Free Source Code

MSSQL avoid multiple prefixes by using alias...

sql sql-server schema linked-server prefixes

Converted data with NUMBER in Oracle to NUMERIC in SQL Server with openquery...

sql sql-server oracle-database linked-server openquery

How to add a where clause conditioning another database to OpenQuery linked server?...

sql sql-server linked-server

Error querying an iSeries DB2 varchar(32000) column from SQL Server over linked server...

sql-server db2 migration linked-server varchar

Setting up Azure Synapse Analytics Linked Service to ODBC linked server...

odbc azure-synapse linked-server linked-service

Incorrect Syntax Open Query...

sql linked-server openedge openquery progress-db

EXECUTE DYNAMIC OPENQUERY INCLUDE VARIABLE IN FUNCTION INPUT...

sql-server dynamic-programming linked-server execute openquery

Cross-server SQL...

sql sql-server t-sql linked-server cross-server

What query can I use to retrieve a list of all tables and columns from ALL linked servers?...

sql sql-server t-sql linked-server

Creating flask-sqlalchemy table object of a table on a linked server...

sql-server sqlalchemy pyodbc linked-server

MSDTC on server 'server is unavailable'...

sql-server linked-server msdtc

Insert results of linked server into temp table from SQL Server 2016 to SQL Server 2019...

sql-server-2016 linked-server sql-server-2019 sp-executesql

SQL Alter Sequence on remote server...

sql-server t-sql sequence linked-server

Insert by date using Openquery using SQL Server Linkedserver?...

sql-server linked-server openquery

Copy Trigger stops row being inserted...

sql-server database triggers linked-server

SQL Server 2019 Express : reading from / writing to SQL Server database (serverless) - working in SS...

sql-server azure-sql-database linked-server

MSSQL: Transaction Isolation Level with Linked Server...

sql-server locking linked-server

Can't connect to Azure SQL Server from 1/3 of our servers...

sql-server azure-sql-database linked-server

Authentication failed when querying data from linked server with SQL authentication...

sql sql-server linked-server

Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for...

sql-server file-permissions windows-server-2012 linked-server

Issues while Using Nested DB Link queries in AWS RDS SQL Server...

sql-server amazon-web-services linked-server

Iterate through a list of servers in SQL Server...

sql sql-server loops linked-server

Linked server query slow, statistics taking a long time to return...

sql-server linked-server columnstore

Error: OLE DB provider "MSDASQL'' for Linked Server ''bequick'' was una...

mysql sql database odbc linked-server

Query tables between two different servers in SQL Server...

sql sql-server azure-sql-database linked-server azure-synapse

MSDASQL provider throws error for cloudera Impala : Requested conversion is not supported...

sql-server odbc cloudera impala linked-server

Avoiding SQL injections with complex dynamic SQL targeting OLEDB Linked Server...

sql-server oledb sql-injection linked-server osisoft

SQL Server: accessing CSV files as linked server with Windows authentication...

sql-server csv linked-server

What could be the workaround to avoid the MERGE issue i.e. The target of a MERGE statement cannot be...

sql sql-server t-sql linked-server

SSMS - Linked Servers - Azure...

mysql azure ssms linked-server