Service Broker cannot find stored procedure

Question

We keep running following error from Service Broker:

Could not find stored procedure 'spInsertLines'.

I had put a Trace on the database to see what causes store proc to drop but trace shows that stored procedure wasn't dropped. Why would service broker think that stored procedure has disappeared? After recreating the stored procedure everything works fine for some time and then error shows up again.

---

SQL Pro

Answer 1

Check, if there are no privilege changes for the stored procedure.

Then verify if user used by Service Broker have all privileges - try to login as this user and execute SP.