I am running transactional replication with a push transformable
subscription. I am running into a PK error. After researching the error I
have found two transactions tied to record in the subscription database. So I
use the following to determine which transaction is getting ...

Hello...
We have some tables that had been using Identity columns as a Primary
Key...but we abandoned that approach a few weeks ago and adopted GUIDs
instead.

Some hopefully simple questions for the replication experts!
SQL Server 2000, transactional replication, one publisher, one
subscriber.
I have added a column to an article on the publisher and the publisher

I have a database with SQL Server 2000 and many MSDE. I need to replicate
all MSDE database to the central Server, which is SQL Server 2000. Also I
dont need to replicate from central database to all other MSDE database. So
central database just acts as backup for all MSDE and ...

I've recently set up a new server using SQL Server 2005, and have migrated
all my public databases to it. However, I still have the old server with SQL
Server 7 and would like to use it to offload reporting from the 2005 server,
and as I've already got transactional replication ...

Can someone give me a pointer on how to set up a replication server?
I've browsed the replication documentation, but I just want to know
what the experts suggest for what I want to do.
I have two servers, Office and Home, with Internet access over 384k

In regards to Transactional Replication, using a pull subscription through a
firewall (distributor and publisher are on the other side of the firewall)
and SQL authentication - is anything other than port 1433 required for this
to work?

CREATE TABLE SALES
(sale_id INT IDENTITY (1,1),
sale_region CHAR(2)  )
When replicated, the IDENTITY property is lost. If the Publisher crashed and

I have a new issue...
I created a publication. It's a Updatable Transaccional Inmediate Updating
replication.
My C.S.I. is:

Good Day.
I have a server running SQL Server 2000 SP4 as the Distributor and
Pulisher. I have multiple XP systems with MSDE SP4 installed as the
subscriber.  The Databases on the XP systems have a database created

I need to install a service pack on replicated servers.  Server A replicates
to Server B and vice versa.  From what I understand (but correct me if I'm
wrong),  I'll need to "Quiesce" the servers and install the service packs
simultaneously.  But what does that mean.  I looked at ...

Hi is there any way to drop an article in EM which is part of a larger
publication which contains other articles,  as the article I wish to drop
appears with the tick next to it in the publications under articles but it
does not allow me to untick this which seems strange. Is ...

 I met a problem this morning. the merge replication agen stopped, the
error message shows:
      The process could not enumerate changes at the 'Publisher'.
      (Source: Merge Replication Provider (Agent); Error number: -2147200999)

I have merge Replication MSSQL Server 2000 SP4, One Publisher and 5
subscribers,
a)      Subscribers1 has inserted the record at 8 AM and Send it to
subscribers2 & subscribers3

Good Day,
After running Merge Snapshot Subscription Job No BCP files are created
for the data tables:
here is my code for the Merge Articles: