• Seems like the code did not work for me at first either. as the earlier posts suggested, i enabled the service broker, and then created a master DB key for my DB.

    sys.transmission_queue had the following message:

    "The session keys for this conversation could not be created or accessed. The database master key is required for this operation."

    I then issued this:

    CREATE MASTER KEY ENCRYPTION BY PASSWORD = ''

    re-ran the code sample as presented in the article, and it worked.

    The WITH ENCRYPTION=OFF should have also worked as another poster suggested.

    Steve