SqlDependency Only firing event once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey gang.

I am just learning the SqlDependency class for the first time. I am really
thankful for this class I believe. I thought I was going to have to do SQL
CLR Trigger that called my WebService.

Anyways, I am using the SqlDependency.OnChange event and its working great
except that it only fires once. If I make a 2nd change to a field in the
table, it doesn't fire a second time.

Is there any reason for this? What have I done wrong? The first response
comes back perfectly as expected.

Thanks and take care.
 
Back
Top