>Hello,
>
>I am having an issue with replication.
>
>This is what I am trying to do.
>
>I have Server1 that has SQL 2000 Standard and Server 2 that has SQL 200O Enterprise installed.
>
>I have tried to initiate Transactional replication from Server1 to Server2 without any luck.
>
>Could someone please point me to a step by step guide on how to setup replication.
>
>Also, for some reason, when I double click on Server 1 SQL Server Service Manager, I do not see Distributed Transaction Coordinator. This has got me wondering if there is something up with Server 1.
>
>Anyhow, I honestly expected myself to spend an hour configuring first Merge Replication then Transactional Replication but obviously this is not the case.
>
>Thank You for all your help. As soon as I get this answer, I will head over to the office to try this out.
>
>Thanks again

Alvin,

Unfortunately, there is no simple, concise step by step guide to setting up replication because there are a lot of options, each tailored to the needs of your system, and each equally neccessary for successful replication. There are a lot of published "Bibles" if you want to try one of them out.

Also, replication is not a "setup and forget" deal. It requires active managment to make sure that it is running correctly.

SQL Server 2000 replication doesn't differentiate between Standard Edition and Enterprise Edition, so I would concentrate on other areas to solve the problem.

Perhaps we can work through getting you started via this thread:

1. Is the database home-grown or a part of a vendor supplied system?

2. What is the purpose of replicating the data (disconnected/distributed updates, redundancy, or reporting)?

3. How big is the source database (# of rows, GB)?

4. How often is the original database updated?

5. Are the updates inserted records, or updates of existing rows?