sql server notification services: I'm just trying to understand better how SqlCacheDependency and
notificaiton services work. I got it all setup and apparently
working. When I run sqlserver2005 trace utility it shows the stored
procedure SqlCachePolling constantly being executed. (kind of like it
is polling). Is that how the notification services work? Is it
really just polling for changes in tables I am watching.
Peter Kellner

dear peter

i think like many others you are confusing Query Notifications which
uses polling of indexed views and is a new native sql2005 feature with
Notifiaction Services which is an optional component platform for
building bulk notification applications.

This forum covers the latter, suggest you try the sql2005 forums for
QN.

kate

Hi Kate,

thanks for helping me understand. Could you elaborate a little more
please. If I'm using asp.net and their Cache classes and I don't want
the database polling with lots of overhead, is there some other way to
do Cache that is better? I'm really just trying to understand what I
need to learn (if it's available from Microsoft) to best do caching
without polling and proper data integrity.

Thanks

Peter Kellner
http://peterkellner.net


[quoted text, click to view]
Peter Kellner

Dear Peter

best you post this question to the sql server or .net forums where you
will get a more complete answer.

kate