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

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)

|||

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

|||

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)