Service broker with SqlNotificationRequest

Posted by user171523 on Stack Overflow See other posts from Stack Overflow or by user171523
Published on 2010-03-29T03:46:08Z Indexed on 2010/03/29 3:53 UTC
Read the original article Hit count: 540

Filed under:

servicebroker

|

notifications

|

triggers

I am in the process of evaluating a Service Broker with SQL noticiation for my project. My requirements is User places a order from System A and it will update Order Table. As soon as order is place i need to notify the System B. I have done a quick POC with Trigger , Service Broker and SQLNotificaiton ADO.NET. It is working as i expected.

What i would like to know the group A) What are the best practices i need to follow for this? B) What are disadvantages with the above approach if any? C) Are there any disadvantes of using the Triggers? If so what are those for above approach?

The order table will get order from System A like 1000 to 1500 every day. I also would like to know the performance of above approach.

© Stack Overflow or respective owner

Related posts about servicebroker

How do I get the size of a Service Broker Queue quickly when the table is >500k rows?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to determine the total size of a Service Broker Queue and transmission queue when the queue is very large. The problem is traditional querys like the ones below don't work since it's not a table. Any ideas? EXEC sp_spaceused 'sys.transmission_queue' SELECT rows FROM sysindexes WHERE… >>> More
Service broker with SqlNotificationRequest

as seen on Stack Overflow - Search for 'Stack Overflow'
I am in the process of evaluating a Service Broker with SQL noticiation for my project. My requirements is User places a order from System A and it will update Order Table. As soon as order is place i need to notify the System B. I have done a quick POC with Trigger , Service Broker and SQLNotificaiton… >>> More
CodePlex Daily Summary for Tuesday, February 15, 2011

as seen on Code Plex - Search for 'Code Plex'
CodePlex Daily Summary for Tuesday, February 15, 2011Popular ReleasesAllNewsManager.NET: AllNewsManager.NET 1.3: AllNewsManager.NET 1.3. This new version provide several new features, improvements and bug fixes. Some new features: Online Users. Avatars. Copy function (to create a new… >>> More

Related posts about notifications

libnotify (ubuntu kind of) notifications instead of Ayanta Notifications on kubuntu

as seen on Super User - Search for 'Super User'
Basically, in the beginning I had ubuntu installed. Then I installed "kubuntu-desktop" package. In the beginning, I didnt like the default notification, so I changed to Ayanta.. Now, I installed few packages and now my notifications are similar to what they looked like in ubuntu. How do i get… >>> More
How to enable default notifications with notify-osd?

as seen on Super User - Search for 'Super User'
Some time ago I found that pretty ubuntu notifications are available as a package notify-osd in ArchLinux. I installed and tested it. The question is how to enable notifications running by default in ubuntu (volume up/dpwn, backlight, some programs notifications, etc)? I'm using XMonad WM instead… >>> More
How do I send automated e-mails from Drupal using Messaging and Notifications?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on a Notifications plugin, and after starting to write my notes down about how to do this, decided to just post them here. Please feel free to come make modifications and changes. Eventually I hope to post this on the Drupal handbook as well. Thanks. --Adrian Sending automated e-mails… >>> More
Azure WNS to Win8 - Push Notifications for Metro Apps

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Background The Windows Azure Toolkit for Windows 8 allows you to build a Windows Azure Cloud Service that can send Push Notifications to registered Metro apps via Windows Notification Service (WNS). Some configuration is required - you need to: Register the Metro app for Windows Live Application… >>> More
Is there a library for notification/alert in .NET?

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to design a notifications framework written solely in .Net. I was wondering is there were some libraries already available to ease in creating rules for the notifications. PS: Anything other than SQL Server Notifications please. Note: Notifications as in Emails and SMS notifications. >>> More