sql server notification services: I've noticed that in addtion to the NS<SubscriptionClassName>View, there is
alway a view simply named as <SubscriptionClassName>. Could somebody explain
to me what the differences are between these two views? I can only find
documentation on the NS<SubscriptionClassName>View on MSDN. Thanks a bunch
in advance!

[quoted text, click to view]

I have the same question. The reason is that for me, one of the views
returns data and the other doesnt, The <SubscriptionClassName> view doesnt
return to me any results when i have created subscriptions, and unfortunately

When the generator fires, it materializes some views over the events
and subscription tables. These views, named for the event and
subscription classes (without the 'View' on the end), contain the
events and the subscription data that will be processed during this
quantum period. These views should be used in your match rules because
they take care of the scoping - that is you don't have to worry about
distinquishing old event/subscription data from new event/subscription
data.

The <SubscriptionClassName>View provides a way for you to manipulate
subscription data using T-SQL rather than through the SSNS API. You
can create subscriptions, etc, using that view.

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)



[quoted text, click to view]