 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Service Broker / July 2007Query Notification in SQL2K?
Hi, Is it possible to implement Query Notification in SQL2K? Any help would be greatly appreciated. Leila What is "query notification"??  SignatureTheSQLGuru President Indicium Resources, Inc. > Hi, > Is it possible to implement Query Notification in SQL2K? > Any help would be greatly appreciated. > Leila > What is "query notification"?? SQL Server 2005 feature, allowing a "push" to applications when the result of a query changes. http://msdn2.microsoft.com/en-us/library/ms175110.aspx I know of it, but have yet to try using it. Sounds kind of like voodoo to me. :-) SignatureAaron Bertrand SQL Server MVP Try this link. It should give you everything you need: http://www.microsoft.com/downloads/details.aspx?familyid=79B34DA2-185F-455C-9365 -96FFBC6DA608&displaylang=en -Mike > Hi, > Is it possible to implement Query Notification in SQL2K? > Any help would be greatly appreciated. > Leila Thanks Mike, As far as I know, SQL Service Broker is required to notify clients about data changes. Are you sure that SQLNS can be used in this context? Are there any document about this? > Try this link. It should give you everything you need: > [quoted text clipped - 6 lines] >> Any help would be greatly appreciated. >> Leila Here is a link to a full MS Technical Overview of NS for SS2k. It does not require Service Broker. The article talks about queuing of messages. Changes to tables in NS would be an Event that a subscriber would subscribe to. Code would have to be written that captures the event. This link gives a lot of information on the architecture. http://www.microsoft.com/technet/prodtechnol/sql/2000/evaluate/sqlnsto.mspx Here is another link containing links to more info\resources including WebCasts, code, etc. http://search.technet.microsoft.com/search/Default.aspx?query=notification%20ser vices&brand=technet&locale=en-us&refinement=00&lang=en-us -Mike > Thanks Mike, > As far as I know, SQL Service Broker is required to notify clients about [quoted text clipped - 11 lines] > >> Any help would be greatly appreciated. > >> Leila SQL Server Notification Service != Query Notifications. It's more of an overloading of the word "notification". Not to say you couldn't code something up using triggers and MSMQ and SQLNS, but it's not the same feature. The did implement "ASP.NET cache sync" on top of SQL2K, but its an entirely different implementation than SQL2K5. It uses polling rather than broker and query notifications. But query notifications itself requires SQL2K5. Cheers, Bob Beauchemin > Here is a link to a full MS Technical Overview of NS for SS2k. It does not > require Service Broker. The article talks about queuing of messages. [quoted text clipped - 29 lines] >> >> Any help would be greatly appreciated. >> >> Leila Hi Leila, No you can't; Query Notifications uses Service Broker for the plumbing. I presented on this last Thursday, my demos and decks are here: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/07/19/content-from-my-ch eltenham-presentation-query-events-notifications-sql-hints-and-tips.aspx Make sure you aren't confusing Notification Services with Query Notifications which are completely seperate things. Tony SignatureTony Rogerson, SQL Server MVP http://sqlblogcasts.com/blogs/tonyrogerson [Ramblings from the field from a SQL consultant] http://sqlserverfaq.com [UK SQL User Community] > Hi, > Is it possible to implement Query Notification in SQL2K? > Any help would be greatly appreciated. > Leila |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.