Event Notification on Server

  • Marek Grzymala

    SSCommitted

    Points: 1890

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

  • Danny Ocean

    SSCertifiable

    Points: 6098

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

    Thanks for question πŸ™‚

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

  • Lokesh Vij

    SSChampion

    Points: 10836

    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

  • Koen Verbeeck

    SSC Guru

    Points: 258907

    Nice question, thanks!

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

  • Carlo Romagnano

    SSC-Insane

    Points: 21712

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

  • Danny Ocean

    SSCertifiable

    Points: 6098

    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 !!!

  • sestell1

    SSChampion

    Points: 10230

    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.

  • palotaiarpad

    SSCarpal Tunnel

    Points: 4867

    Arrrgggh. First thought was right! :crazy:

  • Dana Medley

    SSCertifiable

    Points: 6764

    palotaiarpad (5/22/2013)


    Arrrgggh. First thought was right! :crazy:

    +1. Never should have doubted



    Everything is awesome!

  • DugyC

    Hall of Fame

    Points: 3804

    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]

  • Revenant

    SSC-Forever

    Points: 42467

    Danny Ocean (5/21/2013)


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

    Thanks for question πŸ™‚

    Another +1

  • TomThomson

    SSC Guru

    Points: 104763

    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

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    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/

  • Ken Wymore

    SSCoach

    Points: 16354

    Nice question. I too had no idea.

  • Bangla

    Hall of Fame

    Points: 3137

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

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

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