I need to connect to other sQL Server in other server machine.
But there is security policy in the company that doesn't allow us to use:
linked server method.
I'm thinking about using opendatasource method, but the problem is to use opendatasource we need to have Server Role as Sysadmin. And it's also now allowed.
Is there any method or function that doesn't require sysadmin nor linked server?
Please help. Thanks.