Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Query Notification Support SQL 2008

 
   Database Help (Home) -> Notification Services RSS
Next:  Mass-Exposure Promotion Service 44663  
Author Message
voodoobuda

External


Since: Aug 12, 2008
Posts: 2



(Msg. 1) Posted: Tue Aug 12, 2008 12:07 pm
Post subject: Query Notification Support SQL 2008
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

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?

 >> Stay informed about: Query Notification Support SQL 2008 
Back to top
Login to vote
Sanjeev Rampersad

External


Since: Sep 30, 2008
Posts: 2



(Msg. 2) Posted: Wed Oct 15, 2008 3:26 am
Post subject: Re: Query Notification Support SQL 2008 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" wrote in message

> 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?
>

 >> Stay informed about: Query Notification Support SQL 2008 
Back to top
Login to vote
shane

External


Since: Jan 28, 2010
Posts: 1



(Msg. 3) Posted: Thu Jan 28, 2010 6:21 am
Post subject: Re: Query Notification Support SQL 2008 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Aggregated Query not working in Query Notification - Any i.. - We are using an aggregated query for query notification MSDN says you can use count_big() and sum() with group by clause. select entry_date, count_big(entry_date) as cnt from dbo.my_stats where entry_date > '2008-04-10' group by entry_date entry_d...

"Notification Services" compared to "Query Notifications" - Hello everybody, Can anybody explain be the difference between "Notification Services" and "Query Notifications"? At the moment I'm using the SqlDependency class which, as i think, is based on "Query Notifications". This m...

notification services - - Hello, I am getting this error while running notification services Message: 4120: The number of events in this quantum is greater than the throttle specified for events. Some of the event and subscription views could not be materialized. ...

Receive notification about rows changes. - Perhaps somebody can point me to good step-by-step guide to solve my very common task. There is table "SomeTable". There is field "Status" there. Some process need to process rows in that table when "Status"="Pending&qu...

Notification services or another mechanism .. how do I ... - Greetings all, I am browsing this newsgroup looking for a mechanism to notify my external application when there is a change in my database. And I would like a push in the right direction to find the right mechanism. I have seen discussion around..
   Database Help (Home) -> Notification Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]