Query Notification Support SQL 2008

voodoobuda wrote on 08/12/2008 21:07 :
> Is Query Notification Services supported in SQL 2008?
> If not…
> How are we going to move to the new SQL 2008 without a work around for Query
> Notification Services?
Bit of a late reply but had a similar question and found the answer here:

Using Query Notifications
SQL Server 2008 Books Online (November 2009)

http://msdn.microsoft.com/en-us/library/ms175110.aspx

"The Database Engine uses Service Broker to deliver notification messages.
Therefore, Service Broker must be active in the database where the application
requests the subscription. The query notification functionality does not require
or use Notification Services. Query notifications are independent of event
notifications."

Query Notifications are not the same as Notification Services.
Notification Services (SSNS) are not included in MSSSL 2008 whereas Query
Notifications are. I use the SqlCacheDependency .Net class for invalidating
cached items in ASP.Net applications, and also needed to know if this class
would continue to function correctly in MSSQL 2008 seen as SSNS was no longer
included.
 >> Stay informed about: Query Notification Support SQL 2008