sql server notification services: Hi,=20

I have a requirement I would need the NS to process multiple events. =
There would be different subscription for every different event.=20

But the notification remains same. The notification will go to a single =
subscriber.=20

Can I configure this on a Notification Service? How would the structure =
in ADF go?=20

Regards,

Hi Yogesh -

[quoted text, click to view]
No problem. SQLNS can have multiple events coming from multiple event
providers. You can even have multiple event providers submitting
events into the same eventclass if you'd like (ie FileSystemWatcher
and SQL Server Event Provider into the same EventClass)

[quoted text, click to view]
Okay.

[quoted text, click to view]
The same notification class for all subscriptions? In the schema for
the NotificationClass, you're going to need to define a field for each
piece of information from every subscription class that will generate
notifications. This means the the notify function will have those
fields as arguments and that each subscription class will have to
submit the relevant data and stuff non-relevant fields with place
holders.

[quoted text, click to view]
The application that you've mentioned in another post?

[quoted text, click to view]
I haven't set this up myself, but I don't see why not.

HTH...

--
Joe Webb
SQL Server MVP


~~~
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)


On Fri, 22 Jul 2005 14:42:44 +0530, "Yogesh K."
[quoted text, click to view]