Not a replication specialist, but it looks like there are replication transactions that have not yet replicated to all subscribers. How space is bein used in the T-Log?

You already have a thread open regarding this here.

Do not post responses here.

I have no idea. You haven't provided us with anything to work with here.

Gianluca Sartori (6/30/2009)

---

... if I ever come to an end!! I'm quite busy in these days and tomorrow I'm taking my wife to the hospital for the birth of my...

Give the attached code a try. You need the code in both files.

Are you entering any values into the Notes column during this process?

Differences in the query engine. Perhaps in SQL Server 2000 the WHERE creteria ISNUMERIC(...) = 1 may have filtered records out before the creteria with the CONVERT on it...

What is the recovery model of the distribution database?

Just curious, but, since you are using litespeed are you compressing your backups?

Gail, you'll like this one. The OP wants us to use our crystal ball to help solve his problem.

Don't know about you, but mine seems to be permanently cloudy.

We really can't help you based on the extremely vague description of your problem/issue.

If this is a performance problem, please read the second article I have referenced below in my...

GSquared (6/30/2009)

---

No more waiting required. Let me know...

You will also want to run the Database Upgrade Advisor against the database. There may be things you need to modify/change before moving to SQL Server 2005, others after...

Mind decoding your dates??

Roy Ernest (6/30/2009)

---

David, That was funny... Gail, Grant, Lynn, Jeff, GSquared and all of you the Ghost busters... :hehe:

Lynn, you were posting at break neck speed today.. Jumping one forum...