I am planning to use replication over the internet, but was told that
replication is meant to be used over a network ? Before I start
development I want to find out if replication over the internet is a
reliable solution and what I need to have in place before I start.

How can we achive a SQL server merge replication over the internet when both the client and server are Windows Xp machines and using SQL Server 7? Can someone please explain in a clear step by step fashion?

In Enterprise Manager (EM), if you go to: [Replication Monitor -> Agents ->
Merge Agents] you'll see a list of Merge Agents to the right.
I'd like to be able to select one of the items, right-click, and select
"Agent Properties".

Totally stumped. How I got here ...
I've had a database set up for merge replication. Initially it had 2
publications, but I just scripted them out and deleted them when I ran into
this issue, so there are currently no publications on the database.

I'm using a custom conflict resolver (using stored procedure) for one of any
articles.
I want to determine which columns were in conflict in this stored procedure.
Could you pls point me to some pointers on how to achieve the same.

Does anyone know if it is possible to add a formula field as column of a
replicated table?
How can I do it?
Thanks,

Hi to everybody.
Situation:
1) merge replica
2) Two publications with many subscribers (about 60 for each publication).

I would like to add a field to a table that is the target table in a
transactional replication. The source table does not have this field (and
never will). Can it be done without interfering with the existing replication?
Thanks in advance,

I am new to SQL and facing problem creating merge replication, searched MS
site but found nothing on it
I have created a new merge publication with all the tables in a DB, this
error occurs wile snapshot agent starts to create the snapshot error is

We have a merge replication configuration with the distributor and subscriber
on one server and the publisher on another.    The performance of the merge
slows down more and more as runs.   The bandwidth between servers has already
been ruled out because there they run on a Sonet ...

I want to be able to replicate large volumes of data over the Internet
between SQL Server 2000 databases. The transmissions would be once per day,
need to be secure, and are to a location three time zones away.
What do you recommend for testing, security, support (the whole nine ...

I have a table that is in both merge and transactional replication and I
would like to add a column to it.  Typically, when I add columns to tables in
replication they only exist in one table, so I just go to the publication
properties and add it use the add column button.  This ...

SQL 2000.
I have a merge replication system running in a 24/7 environment that
cannot be brought offline or locked up.  When i try to run my snapshot
agent, it locks up the primary DB (there are many tables in this that

Hilary.
I am looking for the troubleshoting section of your book
about the snapshot agent.  Basically, it says you really
shouldn't have many errors when it comes to the snapshot.

What are the steps for changing the identity range values?
We have backup the database that contained initial publication with
identity range set to 1000. Now when I delete the existing database with
replication, and then create a new DB with same name and restore the