Hi there,
I am trying to add sql cache dependency in .Net, but no joy.
I followed the steps in the following article:
http://www.simple-talk.com/sql/sql-server-2005/using-and-monitoring-sql-2005-query-notification/
Everything seems to be OK - the broker is set, the permissions are set, when I call sqlDependecy.Start() I can see that the service and sp are created in the db.
However when I actually create SqlCacheDependency and add to the cache I don't see anything in the Profiler and sys.dm_qn_subscriptions remains empty.
I am using fully qualified table names in the sql query inside the dependency.
Does anyone have any idea why it is not working.
Many thanks
N