Query Notification Support SQL 2008

[voodoobuda]

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?

[Sanjeev Rampersad]

This is not support ed in SQL 2008.
I think the reason is that it was not used enough in 2005 for it to be
continued in 2008.

Have ou ever used 2005 to send sms notifications?
If so, how have you done this?

"voodoobuda" <voodo...@discussions.microsoft.com> wrote in message
news:5640B4B3-AD31-4736...@microsoft.com...

> Is Query Notification Services supported in SQL 2008?

> If not.

[shane]

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.