Each instance, or server, needs its own endpoint.

You'll also need to generate the route on each side to the other, so you can send close dialog messages and the like.

Paul, thank you.

Please don't feel I'm ignoring your comments if I don't provide an immediate answer on this while I wrap my head around all the information and recommendations.

The first...

For an instance of WHEN to use it, an example would be conditional flowing. By enabling/disabling different containers, you can have your script task perform an If/Then structure that...

You need to setup endpoints.

The best Service Broker basics/walkthrough I've seen, by Adam Machanic:

http://www.simple-talk.com/sql/learn-sql-server/service-broker-foundations-workbench/

http://www.simple-talk.com/sql/learn-sql-server/service-broker-advanced-basics-workbench/

Dead on target.

Also, take a look at those...

Paul White NZ (12/11/2010)

---

Craig,

Thanks for that, it helps a great deal. Just one more question before I get to the good stuff.

The delta/replacement files you get for historical edits:...

WayneS (12/11/2010)

---

Craig,

Any chance of getting an execution plan on that first update (the 6 hour one)? Also, can we get updated Delete/Insert/Update plans after you implement the 3rd suggested index...

WayneS (12/11/2010)

---

Craig,

Edit: Whoops, this plan is for the update in the cursor, not the initial 6 hour one. Still, it is taking about 8 minutes per batch - this index...

Paul White NZ (12/11/2010)

---

Craig,

I've spent a good bit of time looking at the script and the execution plans. There's a fair bit to say about them at face value,...

Enterprise afaik. I'll double check Monday when I'm back in the office.

WayneS (12/10/2010)

---

Is it just me, or do others also see that the quantity of technical posts has dropped considerable lately? I know all the schools are closed, but there were...

You've got the idea. I personally would delete from the bottom tables up, just so when you do get around to properly putting in foreign keys this doesn't break.

Your...

Sighs.

Typo, he meant <> instead of !=, and he's right.

TOP(n) is proprietary, and you have...

Take a look into full text indexing. This is probably your best bet for speed here, though it does require some upkeep.

Oval?

We really need more information here.