• SQLKnowItAll (4/2/2012)


    Yup! Stepping away and observing because this is clearly not what I thought... 🙂

    I think digging at the setup for db_mail is fine; we've got to get Welsh from getting distracted with other error messages and stay on track with db_mail for now.

    It seems to me the issue's more related to the service broker not processing the emails in the queue; He's said that he's stopped and started the service, which is how he'd fixed a very similar issue in the past in another thread.

    I'd like to see the results of some of the broker related DMV's for more information;

    Service Broker Related Dynamic Management Views (Transact-SQL)

    How to troubleshoot Service Broker problems

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!