Message not being sent while auto activating a procedure from a queue

Question

So...
I have a queue that activates a procedure when in it receives a message.
This procedures (let's call it procedure A) calls another procedure (let's call it B)
procedure B function is to log the activity of procedure A in another queue

the problem is... that process B isn't logging anything in the queue...
if I call procedure B by itself it does work like it should...
and if I take the code from procedure B and put in A... it also work (but I shouldn't do it this way)


So what's going on?
Is there a problem when an autoactivating procedure calls another?

BTW this is on sql 2005

Thanks,
Renato Fontes

Answer 1

Hi Renato,

Are procedures A and B in different databases? If this is the case than your problem is likely caused by activation security context being trusted only in the activated proc's database. Remus has a good article (with links to relevant Books Online topics) that explains it: http://rusanu.com/2006/01/12/why-does-feature-not-work-under-activation/ .

Answer 2

Thanks for the help....

It had to do something with permissions hehe

Even though it was in the same database I had different users and schemas for each procedure

I'll read that article thanks