SQL Server Notification Services

26 Oct 2006 5:54 AM

Xavier Decoster

Hi,

I'm working on a Windows-application (c#) and an ASP.NET (c#) website. The
application handles new subscriptions of students in an academy. This
academy had two different locations that uses this same software.
The ASP website can be used by the students to subscribe for a new
education.

I created an MSN-like popup window that should display on the correct
location when a student subscribed throught the site for an education on
that location.

I thought Notification Services would be usefull to solve this problem. The
problem is I'm not used to work with this technology, so if anyone can help
me out?

For example:
How to monitor a the StudentsTable for new records?
How to set up such Notification Service?
How to subscribe my Win-software to this SQLNS?

I use SQL SERVER 2005 and VS.NET 2005.

Thanks in advance!

Xavier.

26 Oct 2006 2:53 PM

Marina Levit [MVP]

I found using NS only worked in the simplest of scenarios, and it was a pain
to configure and especially debug. You configure everything in XML - not
too pretty or user friendly, no intellisense, etc. The debugging especially
was so brutal, it was decided that rolling our own alerting mechanism was
much simpler, more reliable, and much easier to troubleshoot and change.

I haven't heard too much about NS, I'm not sure if this has really picked up
any steam, probably for the kinds of issues I described above.

Show quote

"Xavier Decoster" <xavier.decos***@howest.be> wrote in message
news:%23KOepMM%23GHA.4524@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I'm working on a Windows-application (c#) and an ASP.NET (c#) website. The
> application handles new subscriptions of students in an academy. This
> academy had two different locations that uses this same software.
> The ASP website can be used by the students to subscribe for a new
> education.
>
> I created an MSN-like popup window that should display on the correct
> location when a student subscribed throught the site for an education on
> that location.
>
> I thought Notification Services would be usefull to solve this problem.
> The problem is I'm not used to work with this technology, so if anyone can
> help me out?
>
> For example:
> How to monitor a the StudentsTable for new records?
> How to set up such Notification Service?
> How to subscribe my Win-software to this SQLNS?
>
> I use SQL SERVER 2005 and VS.NET 2005.
>
> Thanks in advance!
>
> Xavier.
>

29 Oct 2006 5:26 PM

Xavier Decoster

First of all, thx for your comments on this topic.

I found it also hard to configure my application and the service in XML,
certainly because the debugging is hardly present.

It's quiet a pitty, because NS could be really powerfull for these problems.
Maybe if they made an easy to use wizard to set things up, it would have
more success.

Anyway,
i kinda solved the problem by creating my own service and eventhandling, but
NS could have saved me a lot of time if i knew better how it works (or why
it didn't work :-))

Show quote

"Marina Levit [MVP]" <someone@nospam.com> schreef in bericht
news:uganl5Q%23GHA.1784@TK2MSFTNGP04.phx.gbl...
>I found using NS only worked in the simplest of scenarios, and it was a
>pain to configure and especially debug. You configure everything in XML -
>not too pretty or user friendly, no intellisense, etc. The debugging
>especially was so brutal, it was decided that rolling our own alerting
>mechanism was much simpler, more reliable, and much easier to troubleshoot
>and change.
>
> I haven't heard too much about NS, I'm not sure if this has really picked
> up any steam, probably for the kinds of issues I described above.
>
> "Xavier Decoster" <xavier.decos***@howest.be> wrote in message
> news:%23KOepMM%23GHA.4524@TK2MSFTNGP04.phx.gbl...
>> Hi,
>>
>> I'm working on a Windows-application (c#) and an ASP.NET (c#) website.
>> The application handles new subscriptions of students in an academy. This
>> academy had two different locations that uses this same software.
>> The ASP website can be used by the students to subscribe for a new
>> education.
>>
>> I created an MSN-like popup window that should display on the correct
>> location when a student subscribed throught the site for an education on
>> that location.
>>
>> I thought Notification Services would be usefull to solve this problem.
>> The problem is I'm not used to work with this technology, so if anyone
>> can help me out?
>>
>> For example:
>> How to monitor a the StudentsTable for new records?
>> How to set up such Notification Service?
>> How to subscribe my Win-software to this SQLNS?
>>
>> I use SQL SERVER 2005 and VS.NET 2005.
>>
>> Thanks in advance!
>>
>> Xavier.
>>
>
>