RBarryYoung (7/14/2009)

---

The only thing that I can figure then is that dropping the Service must also be either deleting or updating the ~25M messages in the queue, which is why...

I got a long wait and then 26,000,000.

I ran it after a receive statement and then got 25.6M.

I also ran a...

Barry

RBarryYoung (7/13/2009)

---

Now that's something I've never heard of before. Can you show us some of the log entries that led you to that conclusion? Or alternatively, what were...

Barry,

I couldn't drop the queue because it was bound to the service.

I dropped the service but it seemed to be logging the op in the tran log. I cancelled the...

Thanks Barry, I sort of worked out most of that, except for creating a new proc. Enjoy your vacation.

The messages have stopped by the service/queue has about 20M...

Sorry if I seem impatient I'm getting worried. Does anyone have any suggestions about my problem.

Should I drop the queue, or the service?

Should I stop the queue first? How...

This problem and the solution is discussed in:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=120549

Buffalor posted the solution below:

"Like Jordanac said above, it will fail on all databases with the SIMPLE recovery model, it...

Hi,

I found the answer in another thread. 

I should have looked more carefully first.

Martin