I would like to use Windows Synchronizations Manager for replicating an
MSDE database. Customers will connect my server from inside their
network using their permanent connection or dial-up. There is no way of
using windows authentication, only SQL.

In merge replication the flow of data by default is bidirectional between
the publisher and subscriber, however this can be overridden if required. In
SQL Server 2005 there seems to be 3 independant ways this overriding can be
done:

In a particular scenario, the customer has a Win XP with SQL Server 2000
Personal Edition. I want to establish replication environment. Obviously
Merge and Snapshot replication is available. Snapshot is not suitable, the
only option is Merge. Some tables must not reflect the ...

I have 2 tables which tab B depends on the record on tab A.  In publisher,
records are generated to tabA before some audit information record to tabB.  
In subscriber, there is replication error that the trigger in tab B couldn't
find the corresponding record in tab A and cause ...

I am going to create snapshot replication which will be scheduled to run
once in a month. my question is about as there are 10 users in my publisher
database, how i can create those 10 users in Subscribers. i know there are
options like i can create manually but i don't want to ...

I need you help to have a best practice that i can use to bring in effect.In
my SQL Server 2000 i have database name XYZ (Production Database) & i have
created another Database on same server as XYZ_Monthly.
As per Reporting requirement at the last day of every month i have to ...

When I add a subscription via a script, the subscription does not
appear in the Replication
Monitor->Publishers->'servername'->'publication' folder in EM.  The
script is being generated by EM.  When I add a subscription via the

During our nightly replication we replicate a table SERV from a third party.
This table contains codes for all open and closed orders from the past 2
years.  It is around 3 - 3.5 GB of total data.  The console starts the first
attempt around 2145 - 2130 and the table runs until ...

We are using SQl 2K with sp4, and using push transaction replication.
Recently we need to add a new field into an existing primary key where it
belongs to a published table.  What is the quickest way for me to replicate
the new primary key over without reloading the data since the ...

We use SQL Server 2000 with merge replication with 500 users.  We are moving
the server and need to temporarily move the database to a different server
while the server is moved.  Is there a way to backup and restore the server
(publisher) without having to create a new replica ...

Does the merge snapshot agent really need to take a snapshot every 24 hours?
I just discovered this, I have some really large tables in merge and am
noticing contention/blocking at the pub each night at midnight...
Can i have it safely do this once per week? Does it really need ...

I have the following issue :
my replication is txn , immediate updating
This is an existing replication and i am changing one of the acct ABC123's
details via the Application.

One application is running in two different locations. The database
structure is the same for both. Each database has its own data. For
replication, I cannot apply snapshot of one to the other because the target
will loose its data. I was thinking of exporting their data to an

Dear Sir/Madam,
I have a replicated database which all data and log file are currently on
RAID 5, and I now would like to move the log file to another drive which is
in RAID10.

I am trying to copy a Subscription db so that I can install it at a remote
site (large file) but am unable do so. I am using SQL Server 2000 and the
remote site uses MSDE 2000.
The Publication properties --> Subscription Options tab has the option for