If A is already distributor all is not lost. You can create a PULL Subscription on B and republish B to C.

Now Republishing does have limitations. If a new...

Amith Vemuganti (3/19/2009)

---

Thanks for the link Noel! Could you tell me how I can move the existing non-partitioned table to a partitioned scheme. I read an article saying we can...

steve smith (3/19/2009)

---

When you say script 'everything', there are caveats there: If there are pull subscriptions, they are scripted on other systems than the publisher. Even with push...

Thanks for sharing.

Actually there are no much more efficient ways to do it, you are on the right track. This is one of the reasons identity columns and replication are...

Well there is only one Queue Reader but you won't get rid of the distribution agents.

Queue reader are to propagate changes FROM Subscriber to Publishers.

Distributors go From Publisher...

homebrew01 (3/18/2009)

---

Sunday, moved 50 databases (total 800 G) from 2000 sp4 to 2005 sp3 onto a VMWare server. This particular SQL server is alone on the VM box, so no...

Google for: SSIS - Fuzzy Lookup

Starting Point: http://msdn.microsoft.com/en-us/library/ms345146.aspx

SET PARSEONLY ON

SET NOEXEC ON

-- Do your thing

SET PARSEONLY OFF

SET NOEXEC OFF

700 replication jobs ?

Is all of that in just one server ?

The problem with "all of its associated tables, columns and values" is "how far" do you want to go with it because there could be an FK pointing to another...

Do you have "Recursive Triggers" Enabled ?

This has always...

If the table is very small you will see that effect.

How many pages does your table has?

From BOL:

The following table lists the minimal amount of new data that should be in a table before you drop indexes.

Indexes..............................................Relative amount of new data

Clustered index only...............................30 percent

Clustered and...