0

I am trying to get query notifications to work, but my application is not receiving any notifications. How do I debug Query Notifications?

I am using the code availble here http://www.codeproject.com/KB/database/chatter.aspx. I can see that the queues, the services and the stored procedures are being created on the server, but the OnChange event on my SqlDependency object is not being fired.

Can I somehow track the notifications?

Jan Aagaard
  • 10,940
  • 8
  • 45
  • 80
  • It's worth checking the "Special Considerations Using Query Notifications" on MSDN, since you might be falling foul of one or more of them - http://msdn.microsoft.com/en-us/library/aewzkxxh.aspx - especially worth checking the SQL Agent service account and SET option settings – Ed Harper Oct 01 '10 at 07:49

1 Answers1

1

See The Mysterious Notification, the troubleshooting tips section.

Remus Rusanu
  • 288,378
  • 40
  • 442
  • 569