microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Multiple notification about the same event

Subject: Multiple notification about the same event
From: "Vadim Rapp"
Date: Fri, 21 Jul 2006 22:35:51 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hello,

after some struggle, I created my first trivial notification applicaiton. One problem I don't quite understand. Let's say, I want to generate notification whenever in the table1 there's new record with col1='x'. Will NS ensure that each such record generates only one notification, or it's something I have to do? if the latter, how?
So far, I based my trivial application on SELECT ID FROM TABLE1 WHERE
COL1='X' ; and NS generates the same notifications about each such row in
every cycle, over and over again.

regards




<Prev in Thread] Current Thread [Next in Thread>