Best instructions I've ever found (via Google) of setting up SSSB between two servers (or instances).

But ... The instructions terminate too early which leaves things in a SSSB Anti-Pattern called "Fire and Forget".

i.e. the InitiatorQueue of DatabaseA should do a RECIEVE of the messages and END CONVERSATION so that SSSB cleans up all it internal stuff. I.e. the message exchange must have an END CONVERSATION on BOTH sides.

If you don't do this your databases (both initiator and target) will grow enormously (depending on message frequency and/or size).

Remus explains: http://rusanu.com/2006/04/06/fire-and-forget-good-for-the-military-but-not-for-service-broker-conversations/[/url]

Maybe an update would be helpful as one of our brave souls followed the instructions six months ago and is now a bit red faced as he has to go back to the solution and clean it all up. :w00t: