[Top] [All Lists]

Query Notification Design?

Subject: Query Notification Design?
Date: 27 Oct 2006 08:37:57 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
When using Sql Cache Dependency with Sql Server 2005 it's my
understanding that you should use Query Notification. My question is
let's say I write a Sql statement with a WHERE clause in it. Does the
cache dependency fire if only the data within that WHERE clause changes
or if anything in the table changes?


<Prev in Thread] Current Thread [Next in Thread>