Thanks Larry. I've finally got some info from my ISP but I have details to take care of.

First, my ISP gave me an IP address, UID and PWD to connect to MSSQL and have told me I should be able to use SEM. What they didn't tell me is how. Do you know "HOW" I should register this remote MSSQL Server over the Internet? I've tried to enter the IP address as the server name but this doesn't seem to work. TIA.

John.

>John,
>If you use the TCPIP protocol to connect in house, there really is no difference. You need to use that protocol over the internet.
>
>1. As Wayne said, whatever format your ISP can accept is what you need to provide them.
>
>2. Actually, you can connect using SEM. It will obviously be slower because the connection via the internet will be slower than you local network but there is nothing stopping you from doing it. If you can connect using QA or something else (e.g. ADO) then you can connect to use SEM.
>
>Your ISP will need to give you an account and access to that DB but that should be no problem as it is your database. They simply will not give you access to any other databases.
>
>3. Replication can be done in a number of ways. Because of security issues at the ISP, I would recommend using a Pull replication job configured on your local server. You could configure the job to run anytime you wanted. It would go out and connect with the database at the ISP and pull all the changes down. There is also a push but you need access rights at the ISP to configure that kind of job and you may not get that.
>
>HTH.