Sql Dependency working procedure

Question

I am using sql dependency in my windows service code..So when ever there is a change in the table where my sql dependency is watch..onchange event is firing in windows service..

I am not able to get any where how actually it is working internally(I know just how it is working as a concept)

I like to know how actually it is working...?

My current issue is Event is not fired when db server is restarted where my service will be in different system and it will be always in started mode.

If any one has any idea on above issues please share here....

Thank you

---

rajesh

Answer 1

I suggest starting from the following link to understand how event notification works.

Understanding Event Notification:
http://ftsearch/docs/temp/8a6940ae-b124-4b04-b365-41cbc0b40f2b.htm

It has other links such as implementing Event notification.

Hope it helps.