SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: SQL Server 2000 Notification Services
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 08/31/2002 :  17:55:17  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Microsoft SQL Server 2000 Notification Services provides organizations with a high-performance platform to build scalable notification applications that generate messages customized to meet their users' specific information requirements. The information updates users receive can originate from a variety of external sources, such as external data feeds and internal business systems, and can be delivered to various mobile devices, including cellular phones and Pocket PCs.

Article Link.

aiken
Aged Yak Warrior

USA
525 Posts

Posted - 09/01/2002 :  01:30:54  Show Profile  Send aiken an ICQ Message  Reply with Quote
I was involved in the beta of this, and I'm still not sure what I think.

One of the things we all love about SQL server is that it makes sense; it's very rare to find an issue in SQL server where you would say "yes, that would work great, but they seriously screwed up the schemas and locking" (other than SQL Mail, which is an issue unto itself).

However, SQL NS is frustrating. It's *almost* right, and will no doubt be fixed in the next rev (or version 3). If you've worked with exchange, you know the issues I'm talking about -- shortcuts, inconsistancies, and generally sub-par schema designs (at least, if you're used to MSSQL 2000).

I would definitely encourage folks to try it, but for the time being we are staying with out homebrew notification system, which has its own serious flaws. Still, it mostly works, and so far I haven't seen any incentive to move from our partly broken implementation to MS's.

Cheers
-b

Go to Top of Page

setbasedisthetruepath
Used SQL Salesman

USA
992 Posts

Posted - 09/01/2002 :  09:00:05  Show Profile  Reply with Quote
Aiken,
How would you compare SQL NS to, say, a MSFT Operations Manager - based notification architecture?

Jonathan
{0}
Go to Top of Page

aiken
Aged Yak Warrior

USA
525 Posts

Posted - 09/01/2002 :  14:51:23  Show Profile  Send aiken an ICQ Message  Reply with Quote
They're really pretty different -- notification services is intended to manage messaging / notification for users of an appliction. For instance, it could easily replace the "subscribe" functions of this snitz message board. Right now, when anyone posts a new message, during the post process Snitz looks up whether anyone is subscribed to the entire board, category, forum, or topic that the post is in, and then generates emails to those people. SQL NS is an application framework that would move that functionality right into the DB, and transparently add support for other notification types (pager, SMS messages, etc).

Cheers
-b

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000