Post reply

Event Notification on Server

  • May 21, 2013 at 11:10 pm

    #294177

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

  • May 21, 2013 at 11:23 pm

    #1617264

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

    Thanks for question 🙂

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

  • May 22, 2013 at 1:09 am

    #1617275

    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

  • May 22, 2013 at 1:53 am

    #1617290

    Nice question, thanks!

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

  • May 22, 2013 at 1:53 am

    #1617291

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

  • May 22, 2013 at 1:57 am

    #1617294

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

  • May 22, 2013 at 6:57 am

    #1617406

    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.

  • May 22, 2013 at 7:15 am

    #1617417

    Arrrgggh. First thought was right! :crazy:

  • May 22, 2013 at 7:29 am

    #1617430

    palotaiarpad (5/22/2013)

    Arrrgggh. First thought was right! :crazy:

    +1. Never should have doubted


    Everything is awesome!

  • May 22, 2013 at 9:36 am

    #1617492

    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]

  • May 22, 2013 at 10:49 am

    #1617516

    Danny Ocean (5/21/2013)

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

    Thanks for question 🙂

    Another +1

  • May 22, 2013 at 11:27 am

    #1617524

    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

  • May 22, 2013 at 12:12 pm

    #1617536

    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/

  • May 22, 2013 at 2:00 pm

    #1617577

    Nice question. I too had no idea.

  • May 23, 2013 at 4:29 am

    #1617789

    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