Event notification and Service Broker

Hot Topic

SQL Beginner
Problems with ODBC
join table udf question
issqluser: how is it set/unset
this should be easy but it's not.
How to Select Delimiter in 'Results to File'
How To Load Periodic SnapShot Fact Table With SSIS
Virtual Labs - No Connection message
Using SQL Login in ASP.Net Authentication
Cannot Install SQL Server 2005

SQL Server

Cube corruption
Execution of Package failed
Failed Install of SQL Server 2005 SP1 CTP
Is this a bug??
Error messages upsizing from MSAccess database to SQLServer
Working Locally but not remotely
Stored Procedure Problem - Couldn't find forum specifically for SP's
HTTP Access to Analysis Services 2005
Set subscriber to other status ?
from SQL 2005 to SQL 2000

Event notification and Service Broker

Hello,

I read in one thread that Event notification can use Service Broker for delivery.
 How Service broker can be used in Event Notification for delivery of notifications

any further links or related article

Thanks in advance
dipz

Answer this question

Event notification and Service Broker

  • IanH

    Hi -

    The two technologies share some of the same terminology, and from a very high level they share a bit of the same functionality, but they are designed to solve different business problems. Unfortunately the shared terminology frequently leads to confusion.

    In the end, Service Broker does not use SQLNS for its event notification.

    HTH...


    --
    Joe Webb
    SQL Server MVP
    http://www.sqlns.com


    ~~~
    Get up to speed quickly with SQLNS
    http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

    I support PASS, the Professional Association for SQL Server.
    (www.sqlpass.org)

     



  • RhysDavies

    Hi -

    "Out of the box" SQL Server Notification Services can send notifications via email or to a file (primarily used for testing and debugging). However, you can write your own delivery protocols to send messages via most any protocol you wish.

    Can you provide a link to the thread that discusses using Service Broker with Notification Services I'd like to read what the posters are saying would be a good integration; I don't know that I readily see it.

    Here's a link to an MSDN article on Service Broker by Roger Wolter. It's a good read and a good place to get familar with Service Broker if you're not already familar with it.

    http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/sqlsvcbroker.asp 


    HTH...

    --
    Joe Webb
    SQL Server MVP
    http://www.sqlns.com


    ~~~
    Get up to speed quickly with SQLNS
    http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

    I support PASS, the Professional Association for SQL Server.
    (www.sqlpass.org)

     



  • markeboyle

    Thanks Joe.
    Here, the link.
    http://forums.microsoft.com/msdn/showpost.aspx postid=99660&siteid=1

    In the reply Roger has mentioned  that "Event notifications use Service Broker for delivery but they are not part of Service Broker. "

    Please let me know if there is relation between Event notification and Service Broker. Can we use Service broker in Event Notification

     Thanks and Regards
    dipz
  • Event notification and Service Broker
Answer this question