Re: Promoted VS. Written properties into message context

Only promoted properties are used for message routing inside the MsgBox (i.e. only promoted properties are considered when evaluating subscription predicates). I haven't looked at the internal implementation, but an educated guess might say that the difference between the two on the object model itself is probably just a flag set or maybe they are kept in separate property collections, but probably not much else. The interesting part all happens in the MsgBox in sql server 🙂