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.