Subject: How do subscriptions classes get associated with ..

I have been using the "Walkthrough: Creating a Stock Notification
Application" to try to understand various aspects of creating a Notification
Services application. When the walkthrough is completed there are two
subscription classes (StockSubscriptions and PortfolioSubscriptions) and two
notification classes (StockNotifications and PortfolioNotifications) in the
ADF.

The event rules for the two subscription classes look virtually identical
except for the sources of the data (i.e. the first gets it's data from
StockEvents and StockSubscriptions and the second from StockEventsChron and
PortfolioSubscriptions) and of course one is an EventRule and the other a
ScheduledRule. Both of the subscription class event rule actions start with:
SELECT dbo.StockNotificationsNotify(s.SubscriberId, s.DeviceName,
s.SubscriberLocale, e.StockSymbol, e.StockPrice)...

So the question is, how do the results of the StockSubscriptions rule action
get directed to the StockNotifications notification class and the
PortfolioSubscriptions rule action get directed to the
PortfolioNotifications notification class? Is there some naming rule
association that I am missing?

Another minor question: There are obviously some rules as to how various
names in the ADF file get translated into actual SQL table names. E.g., the
FROM table names in the SELECT statements are not the real SQL table names.
Are these name translation rules documented somewhere?

Thanks for any help.

--Bob

See the answer to the first posting.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
<a style='text-decoration: underline;' href="http://www.microsoft.com/info/cpyright.htm." target="_blank">http://www.microsoft.com/info/cpyright.htm.</a>


"Robert A. Dukelow" <bob DeleteThis @spawar.navy.mil> wrote in message
news:OY1$CAVBEHA.3712@tk2msftngp13.phx.gbl...
 > I have been using the "Walkthrough: Creating a Stock Notification
 > Application" to try to understand various aspects of creating a
Notification
 > Services application. When the walkthrough is completed there are two
 > subscription classes (StockSubscriptions and PortfolioSubscriptions) and
two
 > notification classes (StockNotifications and PortfolioNotifications) in
the
 > ADF.
 >
 > The event rules for the two subscription classes look virtually identical
 > except for the sources of the data (i.e. the first gets it's data from
 > StockEvents and StockSubscriptions and the second from StockEventsChron
and
 > PortfolioSubscriptions) and of course one is an EventRule and the other a
 > ScheduledRule. Both of the subscription class event rule actions start
with:
 > SELECT dbo.StockNotificationsNotify(s.SubscriberId, s.DeviceName,
 > s.SubscriberLocale, e.StockSymbol, e.StockPrice)...
 >
 > So the question is, how do the results of the StockSubscriptions rule
action
 > get directed to the StockNotifications notification class and the
 > PortfolioSubscriptions rule action get directed to the
 > PortfolioNotifications notification class? Is there some naming rule
 > association that I am missing?
 >
 > Another minor question: There are obviously some rules as to how various
 > names in the ADF file get translated into actual SQL table names. E.g.,
the
 > FROM table names in the SELECT statements are not the real SQL table
names.
 > Are these name translation rules documented somewhere?
 >
 > Thanks for any help.
 >
 > --Bob
 >
 ><!-- ~MESSAGE_AFTER~ -->