Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-31 : 17:55:17
|
| 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
525 Posts |
Posted - 2002-09-01 : 01:30:54
|
| 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 |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-09-01 : 09:00:05
|
| Aiken,How would you compare SQL NS to, say, a MSFT Operations Manager - based notification architecture?Jonathan{0} |
|
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2002-09-01 : 14:51:23
|
| 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 |
|
|
|
|
|
|
|
|
Article: SQL Server 2000 Notification Services