Danny Ocean (5/21/2013)
i have no idea about this topic. I just guessed and got it right.
Thanks for question 🙂
I too hadn't a clue, and guessed. And got it right, of course - if there's a single DB involved surely it could only be MSDB, and the question implies a single DB. It's a nice question despite being easily guessable (at least I liked it, because it sent me off hunting for documentation after I looked at the page referenced in the explanation).
Is this documented anywhere in BOL, as opposed to in the forums? Bing leads one to believe that sys.sysxmitqueue is common to all databases, it isn't just something in MSDB. I'm happy that I didn't know that queue name, as if I had I would of course have got the answer wrong once I searched for MSDN Library references to that table (or maybe not have got it wrong - but certainly been thoroughly confused) - which I did because I would rather find backup from a library reference than trust a forums one, even if it is used in a QotD explanation. The pages found by Bing, that it claims contain that statement, don't actually contain it (they don't tell me that the table is in MSDB either, but I imagine that is true). I've been finding much that is thoroughly irritating with Bing lately. Maybe I'll switch to using Google instead of Bing to search MSDN if I encounter any more such nonsense.