We've got a simple SOP transaction blogged here
http://dyndeveloper.com/articleview.aspx?ArticleID=32
This article extends on that, and adds distributions to the mix. This is a complete example, it will run as is against the two database.