HELP!!! Activation stored proc not firing on queue

[GiJeet]

My activation sp is not firing when a message comes into the queue.
SQL 2005.

I've run the following query to verify that the sp is attached to the
queue and the service:

SELECT Q.*, S.*
FROM sys.services AS S
JOIN sys.service_queues AS Q
ON S.service_queue_id = Q.object_id;

everything look good. Is there a requirement to fire the sp? My
activation sp does not select (peek) or receive from the queue - I use
the sp to only to send and email alert (database mail) that there is a
new message in the queue. if I run the sp manually, eg exec <the
stored proc> it runs fine and works ok. But it does not fire
automatically when a new message hits the queue. Please help with
suggestions. I've tried everything I can think of.

TIA

[Dan Guzman]

> everything look good. Is there a requirement to fire the sp? My
> activation sp does not select (peek) or receive from the queue - I use
> the sp to only to send and email alert (database mail) that there is a
> new message in the queue.

There are no special requirements for the activated proc. Just a guess, but
check the security context of the activated proc. Perhaps that explains why
it runs as expected interactively but not when activated.

Check the SQL Server error log. Errors and messages from activated stored
procedures are written there.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"GiJeet" <gij...@yahoo.com> wrote in message
news:c10c9206-a14b-44d0...@v13g2000vbb.googlegroups.com...