I am forced to admit that application roles still baffle me. Specifically, I have never figured out how to join tables that cross database boundaries using application roles.

For instance...