Ok. I have sorted it out!

Firstly, I checked everything that each of you people posted and having done that, it led me to the answer.

I didn't mention to you people...

Thanks Peterhe. I had a suspiscion that would be the case.

Ok. Nice to know for future.

Thanks.

If you want to find out replication info look in the SYSPUBLICATIONS & SYSSUBSCRIPTIONS tables in the user database.

However, if you want to check on the status of Replication, you...

To be honest. If this is a production Database I wouldn't even contemplate using SQL on a Windows XP Desktop, nor would I contemplate configuring replication on a MSDE platform.

You...

Cool. I learn someting new every day!

Now, what is the problem?

Obviously on a UNIQUE Constraint, it will send the INSERT/DELETE/UPDATE as a pair instaed of a single transaction.

You should probably mention

1. The configurations of each Database.

2. The directory SQL Server is installed in.

3. The directory each Database & Transaction Log is located.

4. The directory each Database...

I think you need to elaborate here!

What are you talking about?

What does "Deferred Update" have to do with Replication?

Is the SQL Agent Service using a Domain Account to start it? If not you will not be able to configure Replication.

It would be better if you removed Replication and then set the NOT FOR REPLICATION on the desired Tables. Once that is done, Then set up Replication again.

If you have configured Snapshot Replication then by default it will DELETE data on the Subscriber.

How did you set up the Subscriber? It sounds like you have created the Database...

It all depends what part of replication is working!

If your wanting to know if the transactions have replicated to the Subscriber & vice versa, then you can intergoate some of...

Thanks wz700. Is the JOIN what's called a Derived Table?

Thanks folks. I will definitely uninstall MSDE first and then install Standard Edition as you have already mentioned, it's a cleaner way of doing it!

Have a look and see if the "Auto Close" is set to on for the Database. if it is turn it off.