SqlDependancy does not work

Question

Hi

I am trying to create a SQLDependency for enterprise library, there is something strange that onChange event never fired.

For SQLServer2005:
Service Broker is enabled.
CLR integration is enabled.

The query is a simple select statement on user defined table, the query is wrapped in sproc.

I have been told that I should find the notification status in sys.transmission_queue table, but it is empty, it seems that no notifications were made.

What is chances?

Thanks

Answer 1

Hi,

'SELECT *' is not allowed change it to 'SELECT COL1, COL2, COL3'

Greetings,

Fons