sql server notification services: Hello All,

I am new to NS, with some experience in using Files and email as the
main mechanism for notifying applications.

In my current scenario, I have a 2 tiered client-server system (.NET)
and I would like to leverage SQL Notification Services to send notices
to the client applications as .NET events. How should I go about
implementing this scenario?

Any help is greatly appreciated.

Kind regards
CD

Hi CD,
The first thing you have to do is create a Customed Delivery Protocol
and when you implement the DeliverNotification() function you can either
send the notification to a queue (MSMQ for example) and make the .NET
application listen to it, or, you can send messages to the application
using Remoting (also from the DeliverNotification() function that you
implement).
I still haven't tried doing it but I also thought about this issue, and
after discussing it with some people we came to the conclusion this is
probebly the best way to do it...
If you come up with other ideas or choose to use one of the
possibilities I mentioned I'll be happy to hear about it !
cheers,
Elad

[quoted text, click to view]


Elad is right if you're going to employ SSNS in your solution. However,
you may also want to look at Query Notifications, a completely different
although similarly named technology.

HTH...

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

I have a similiar requirement would appreciate everyone's thoughts.

My main app runs under VB.Net 2005 and SqlServer 2000. I would develop the
NS app with a custom event providers feeding info from SqlServer 2000 to
SqlServer 2005 NS environment. For matched events, I require notfication in
my VB.Net 2005 / SqlServer2000 environment. A windows form notification as
well as recording the matched event in the Sql2000 db. Many users will be
running with unique and overlapping NS criteria. I will have many diverse
match criteria and will have "event tables".

To visualize, many users will be monitoring stock portfolios with unique and
overlapping stock names. Criteria will be stock price, share traded, %
change yesterday's closing price, % price change versus the last 30 days
average ...

From My research, Query Notification triggers any time the table is touched
(loss of event granularity). My app must respond the the Query Notification
be reading finding by fields within the table by some event code and
timestamp, which specific event NS matched.


Also, I read Microsoft recoomends Query Notifcation be limited to 10
concurrent tracking registrations. Is this limit to a specific table or
across all tables ?

- Eqx

[quoted text, click to view]