What is going on in THE THREAD? Wasnt there a Code ban on THE THREAD? :hehe:

I am glad that we could help.

Elliott W (10/14/2009)

---

While some of the questions have been gems.. Some of the responses, mostly from the inexperienced, are nothing shy of wild guesses based on nothing, let alone...

In general for replication, Index can be dropped and/or created any time any where (Publisher or subscriber). You cannot drop and recreate a primary key though.

Please do let us know if it worked.

When you are dropping the subscription and re adding them, you will be able to initialize using snapshots. Then what ever is missing now will also be there.

Drop the subscription and add it back again. When your SSMS crashed while setting up replication might have not completed the required entries.

Reinitialize the subscription.

Altering primary key I do not think is allowed. You did not say what kind of replication you have.

Yes, it is a problem. Try restarting the log reader agent and the snapshot agent.

Since you have 100s of databases, I think it is safer to have multiple log reader agents. (I am not sure if you can have one log reader agent for...

Grant, On second thought, forget it... 😀 I do not think I want to have nightmares....;-)

The rest of the people in the THREAD can wear a kilt And I dont...

All of you are going to wear Kilt? Can we the of THE THREAD who cannot make it get a pic so that we can see? 🙂

Anonymous you can, but create local account, I still havent seen a link for it. I...

Steve Jones - Editor (10/9/2009)

---

Just an FYI, since THE THREAD is so heavily visited. We've started our own ASK site at http://ask.sqlservercentral.com. Not my idea, and I'm not sure how...