I am doing testing on a database between a SQL Server and a laptop
usingmerge replication.  I can see that each system is missing a record
in each system.  When i run the validation process the system
identifies that the table are not in sync.  Regardless of the

I have a very strange thing happening where the primary key field is getting
changed when synchronizing with a subscriber.  Background:
-Using SQL 2k and merge replication
-Testing with Publisher and Distributor on same server.

I'm not certain if synch over the https is possible for transactional
replication? I did see the setup for merge, but there is no mention of
transactional. Now, is it possible or not? If not, why not?
Second, initialization (access to snapshot) over https? Possible or not?

I'm trying to use the DTS wizard to subscribe to tables located in an
OMNIS datafile. I have the ODBC drivers installed (manu stamp: raining
data), but I constanty get a "Exception_Access_Violation" error.
I'm newish to SQL server and am not quite sure where to start in order

Is it possible for a sqlce database to subscribe to 2 publications publish
from the same server database?
I have the sqlce sdf file created from synchronize with the 1st publication
with the "AddOption.CreateDatabase".

We have a database that we would like to replicate to another server.
Am i correct to asume that the database that is updated would be the
publisher and that the subscriber database would be the replicated copy?

Hi,
I am new DBA doing my first replication troubleshooting. we have a log
shipping application that takes a snap shot of the origin tables, and
generate 4 articles. Four tables are then synchronized using a merge agent,

I need to configure Peer-to-Peer Replication for a database between two SQL
2005 hosts. However I have few newbie questions on doing so:
1. Is it required to have both the SQL servers part of a domain or can this
be achieved with them being in Workgroup mode?

We're trying to create  a replication scheme for a simple data warehouse for
reporting.  I've been looking at the Books Online for SQL Server 2005 and
feel like I've been going around in circles.  Here's a simple case that we
are having problems with.  The prototype for the ...

 I have set up queued updating at local server. i have managed to create a
customer and it got replicated over to the other site.
However, when i tried to modify some details of the customer or even delete
that customer. and when i start sychronize it shows that x commands has ...

In the flowering simplified example there is three tables.
ProjectAssignmentTable, ProjectTable, and ProjectTransactionsTable.
The idea is that an employee is assigned a project in the in the assignment
table and he or she uses merge replication to replicate the project and

I have a 70 GB merge-replicated production database on which I need to
perform some maintenance.  This maintenance will require the removal of my
subscription.  I am trying to minimize downtime, obviously, and wonder about
the ramifications, if any, of setting up a no-sync ...

I'm using Merge replication on a table with an autoidentity field.  All
users are entering data at the publisher (no records are ever deleted),
and at the subscribers the data is read-only.  I'm having a problem
with records being deleted at the publisher.  I'm assuming it has to do

Ok, perhaps I'm a moron.. believe me, I'd be glad to admit it if I
could just get this fixed.
We're trying to merge replicate data via https, we have installed the
CA certificate and can connect to the replisapi.dll through IE. I used

Hi,  
Transactional log on the subscriber is growing so fast that is running of
disk space. I can't truncate and shrink it. What can be done in this
situation?