python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - linked-server

Join LinkedServers

Joins are one of my weak points; I am never sure how to use them and this one is within an Openquery This works when DBs are on the same Server: SELECT top (100) FROM LocalDBl.dbo.LocalTable1 LEFT JOI...
test-img

user3191894

sql-server

linked-server

Votes: 0

Answers: 0

Create trigger in MS SQL Server database to insert/update into another Postgres database

We are changing MS SQL Server to Postgres in our application. The application uses Blue-Green deployment, which is why there will be a period of time when the old version will still work with MS SQL ...
test-img

FireShock

sql-server

postgresql

triggers

linked-server

foreign-data-wrapper

Votes: 0

Answers: 1

Latest Answer

You can try this tutorial and see if it works for you https://www.mssqltips.com/sqlservertip/3662/sql-server-and-postgresql-linked-server-configuration-part-2/
test-img

Nat

Linked Server Certificate issue

I have 2 SQL Servers(2017): A and B. Server_A does not have a certificate and encryption is not enabled. Server_B has a certificate and encryption is enabled. While logged onto Server_A: SELECT * FROM...
test-img

Andy

sql-server

certificate

linked-server

Votes: 0

Answers: 2

Latest Answer

Install a certificate on server A does not solve the problem. If you don't have the certificate you can get the databases list with the relative certificate with the below query see this post use mast...
test-img

Max

SQL SERVER: Accessing Cosmos-Db in SSMS via ODBC

I'm attempting to follow the guide here which shows how to link an azure cosmos-db as a linked server via ODBC. I have created the ODBC links to the remote cosmos-db in both x64 and x86 flavours. Thes...
test-img

Tim

sql-server

odbc

ssms

azure-cosmosdb

linked-server

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs