Helo umutalkim.

I still haven't been able to solve it. I'm setting up a server and doing what Jo Pattyn suggests.Regards

Ok, I'm going to do tests

thanks Jo.

Hello Jo Pattyn.

Microsoft SQL Server 2014 (SP3-GDR) (KB4532095) - 12.0.6118.4 (X64)

Dec 12 2019 21:46:15

Copyright (c) Microsoft Corporation

Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)

izhar-azati, thanks for you message.

I am using 587 port.

Yes, I am using smp.office365.com as smtp

• This reply was modified 4 years ago by  mariomoyeda.
• This reply was modified 4 years ago by  mariomoyeda.

I use Jo Pattyn's option,...

Hello All,

thank you all for your contributions.

The problem was resolved.

Can you use SSIS?  If not Jo Pattyn's option is the better one.  If you're comfortable with SSIS here’s how I/we used to do something similar as part of...

Phil,

The srv3 is a tester machine (plc and other devices)  for this reason exists other local network.

Hello Jeff

For security policies. which this as srv3 is a computer with windows xp and sql server express and cannot be connected to the main network.

Hello Jo

I make this:

Link svr1 to svr2, then link srv3 to svr2.

In srv2 a stored procedure was made to send to svr1.

in srv3 a stored procedure was made to get...

Hello Jo

srv2 is an intermediary to send data a srv1 (main server)

srv3 is a Tester with database, and I want to send since srv3 to srv1

Insert into svr1.DB.dbo.table

Select fields from...