I have service broker running between two instances. That works fine. What I
am doing when I get the response back from the target is to log the response
time and some other information out of the xml (cast as varchar). So I call
the stored proc and it fails everytime. I have a user (ServiceBrokerLogger)
setup that I execute these procs as. If I disable the Activation and run the
ProcessMemberResponses in sql management studio it runs just fine, so I know
it is a rights thing. Also if I change the ProcessMemberResponses to just do
an insert on a local table in the same database that works just fine. So
here is the setup. What else do I need here to get this to work? The rights
of the users are after the scripts.

Alter QUEUE [dbo].[MemberUpdateInitQueue]
WITH STATUS = ON ,
RETENTION = OFF ,
ACTIVATION
(
STATUS = ON ,
PROCEDURE_NAME = [dbo].[ProcessMemberResponses] ,
MAX_QUEUE_READERS = 1 ,
EXECUTE AS 'ServiceBrokerLogger'
)

The activated stored proc

Create Procedure ProcessMemberResponses
With Execute AS 'ServiceBrokerLogger'
AS.......
(the stored proc call)
exec [MemberUpdateLogging].[dbo].[logMemberUpdate] @ConversationID=@ch,
@X=@xml

The target of the activated procedure

Create Procedure [dbo].[logMemberUpdate]
@ConversationID uniqueidentifier,
@X varchar(8000)
WITH EXECUTE AS 'ServiceBrokerLogger'
as

Login Script
CREATE LOGIN [ServiceBrokerLogger]
WITH PASSWORD=N'blahblah',
DEFAULT_DATABASE=[UCC],
DEFAULT_LANGUAGE=[us_english],
CHECK_EXPIRATION=OFF,
CHECK_POLICY=OFF

User Scripts
USE [MemberUpdateLogging]
GO
CREATE USER [ServiceBrokerLogger]
FOR LOGIN [ServiceBrokerLogger]
WITH DEFAULT_SCHEMA=[dbo]
Rights on db
dbDataReader
dbDataWriter
dbOwner
Public
sp_execute

USE [UCC]
GO
CREATE USER [ServiceBrokerLogger]
FOR LOGIN [ServiceBrokerLogger]
WITH DEFAULT_SCHEMA=[dbo]
Rights on db
dbDataReader
dbDataWriter
dbOwner
Public
sp_execute