Currently I'm running SQL Server in house for our Intranet. I'm now planning on having a publicly accessible website that also uses a seperate SQL server. Could someone explain how I would accomplish the following. I want our employees to be able to update the data on our Intranet, and then have the same data updated automatically on the remote SQL server. Is this possible with 2 seperate SQL servers?