I'm currently playing with change notifications in SDAC.
My Database consits of two example tables. I do very simple change notification - queries, like:
select <primary key> from dbo.mytable
With table1 everything works fine. On table2 (on the same database) my changenotification fires on open:
What requierements are exactly meant?'SELECT statement does not meet the requirements for query notification'
Edit:
Some more information: When i try this on a table which is not working it imediatly fires a query notification of the type "query"