Enabling communication between 2 databases on different domains.
Hello everyone, I have a general question regarding updating a database. First of all this is my environment: 1- I have 2 servers. The first have a fixed static ip (private) and is accessible through my LAN network. The second has a public ip. I have databases installed on each server with same schemas. 2- I have a web service deployed on my public server by which i can query and update tables on the database. 3- Both servers are running Windows Server 2008 R2 Enterprise (64-bit). I have a requirement to create a trigger on my first server (with