Event Notification on Server

  • Comments posted to this topic are about the item Event Notification on Server

  • i have no idea about this topic. I just guessed and got it right.

    Thanks for question πŸ™‚

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Danny Ocean (5/21/2013)


    i have no idea about this topic. I just guessed and got it right.

    Thanks for question πŸ™‚

    +1

    I was little confused between msdb and master DB. Some how marked the answer as master db πŸ™‚

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Nice question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • It's easy, all services of microsoft store data in msdb (that stands for "microsoft database").

  • Carlo Romagnano (5/22/2013)


    It's easy, all services of microsoft store data in msdb (that stands for "microsoft database").

    that's the point when i was guessing.

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Thank you for this question. It was quite timely for me, as I've been looking into setting up this exact scenario for auditing server connections. It took me a long time to dig up the answer, as all the documentation I could find said that the transmission queue was created in the sending database, but didn't indicate what the sending database would be for instance level events.

  • Arrrgggh. First thought was right! :crazy:

  • palotaiarpad (5/22/2013)


    Arrrgggh. First thought was right! :crazy:

    +1. Never should have doubted



    Everything is awesome!

  • Danny Ocean (5/21/2013)


    i have no idea about this topic. I just guessed and got it right.

    Thanks for question πŸ™‚

    +1 ...except I got it wrong :blush:

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • Danny Ocean (5/21/2013)


    i have no idea about this topic. I just guessed and got it right.

    Thanks for question πŸ™‚

    Another +1

  • 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.

    Tom

  • L' Eomot InversΓ© (5/22/2013)


    Is this documented anywhere in BOL

    Yes, though not very explicitly (at least not where I found it).

    I found the answer by first realizing that the description in the question implied Service Broker at work, then searching for documentation on using a ROUTE in Service Broker. In that article, an intermediate storage table in msdb was mentioned. I didn't read all the details; seeing the msdb prefix for the table name was sufficient (and I'm kinda busy, so no time to dive deeper in the details). I didn't save the link; sorry for that.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Nice question. I too had no idea.

  • Nice one..I like the design of the question also..:-)

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply