So you are dropping the subscription at the subscriber instead of at the publisher? Any reason why? Are you running the script to create the subscription at the publisher? If...

So, if you create the subscription with the GUI and then drop the subscription does it remove the entry from MSSubscriptions on the distribution database? If it does I would...

More wondering if when you were to create the publication, subscription with SSMS gui and then drop them if it would actually remove that entry from MSSubscriptions in the distribution...

Well, since this isn't working now anyway, I would try to clear that data from the distribution database and try adding it again. Sounds like things aren't getting cleaned up...

There is a script that Jason Massie wrote that can be found HERE which is pretty helpful in finding high CPU queries. The query below will tell you the high...

What do you get when you run select * from syssubscriptions in the publication database? Does the subscription show up there?

Thanks again! I will read the article and I will be looking at this again over the next couple of days - most likely not this afternoon though as I...

ServerIntellect_PC (10/28/2009)

---

David,

I have seen this before and so far it looks like the perf counter is picking up the logins and when a connection is reused. What I have...

Sorry to be a pain here but can you provide a simple overview again of what your layout is like? Something like the following;

Server1 - Publisher - Version

Server2 -...

Steve Jones - Editor (10/28/2009)

---

I think I might suggest removing replication from the 2000 test server and then resetting it up again. I have seen it flaky at times, and...

sqllearner-339367 (10/28/2009)

---

Hello Every one,

Just caught up with some replication question again.

1. Is it possible to publish only selected fields in a table with transactional replication?

2. Is there any...

Very true and great analogy. Thanks for the clarification.

GilaMonster (10/27/2009)

---

<shrug> Two points

SQL is designed to drive the disk queue up. It's not unusual to...

That appears to be a pretty high disk queue length to me. 🙂

The subscription query needs to be run on the subscriber server in the subscription database. That table has to exist there else the other subscription couldn't even be in place....