Query Notifications run 'execute as owner' so if a database is owned by a domain account, query notifications fail in the event a domain control cannot be contacted



Basically, change owner to SA to avoid the issue.

See this writeup

http://aspadvice.com/blogs/ssmith/archive/2006/11/06/SqlDependency-Issue-Resolved.aspx

When sql server got restarted sqldependency connectivity between db server and client code are being disconnected..

so when the sevice is up when there is change in the sql dependency query on change event is not fired..


Anyone can provide solution for this..Plz

When sql server got restarted sqldependency connectivity between db server and client code are being disconnected..

so when the sevice is up when there is change in the sql dependency query on change event is not fired..


Anyone can provide solution for this..Plz

When sql server got restarted sqldependency connectivity between db server and client code are being disconnected..

so when the sevice is up when there is change in the sql dependency query on change event is not fired..


Anyone can provide solution for this..Plz

When sql server got restarted sqldependency connectivity between db server and client code are being disconnected..

so when the sevice is up when there is change in the sql dependency query on change event is not fired..


Anyone can provide solution for this..Plz

Hi,

Great article!

I was wondering if you had any tips if I'm not seeing any query notification messages in SQL Profiler?

I've set my app up following all of the steps above, but after inserting my data into the cache with a SqlCacheDependency, the cached data is never invalidated and removed so it can be fetched with the new values from the database.

Thanks!

-Bill