SqlDependancy does not work

I am trying to create a SQL开发者_Go百科Dependency 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

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