THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Notification Services isn't deprecated in SQL 2k8, it's gone

Darren Neimke posted a link to some great content today from his colleague Steven Nagy. Steven had done a bunch of posts on getting started with Notification Services.

It's a great set of posts but it's important to get the message out that in the next version of the product, Notification Services isn't just deprecated, it's gone. It isn't wise to use it for any new development work unless you're intending to stay on SQL Server 2005 for the life of your application.

For that reason, I've stopped teaching any notification services material in SQL training classes as well.

Published Sunday, February 24, 2008 2:21 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Darren Neimke said:

Thanks Greg, do you know what we should use instead?  I was aware that it was going when I headed down that path, but in the absence of any proper guidance as to what we _should_ be using, I just decided that I'm happy to take the dependancy on SQL2005 - that doesn't preclude us from moving to 2008 for our other SQL stuff.

What were your thoughts on NS?  I actually like it from an architectural viewpoint because it allows me to decouple the subscription management and dispatching of alerts from the application's main codebase.

February 24, 2008 2:25 PM
 

Greg Low said:

Hi Darren,

Sadly, this part of the product didn't follow the deprecation process. It's just gone. Many of the things you could do with it could be emulated via Service Broker queues but the subscription model in NS was much richer.

Alternately, I hear a lot of people say that some functionality will go into Reporting Services. From what I've seen, that seems to refer to the people in the team, not the product functionality. Reporting Services in 2008 doesn't seem to add anything related to Notification Services.

However, there are some scenarios in which you might have used Notification Services where report subscriptions in Reporting Services could be used. These are available programmatically via web services too.

Regards,

Greg

February 24, 2008 6:47 PM
 

Greg Duncan said:

Thanks for posting this Greg, I had missed this... sigh... So much to learn (and unlearn)

February 25, 2008 11:28 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement