.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

msmq triggers and monitoring

Posted By:      Posted Date: October 03, 2010    Points: 0   Category :WCF

I continue to see the msmq model as creating a service to monitor the queue and process messages. But, why poll the queue when there is a trigger mechanism????

SQL Server Service Broker allows for a trigger on a queue and process the message as it arrives, however, it does not play well with .net 4 or service calls. 

How can MSMQ provide the same feature?

View Complete Post

More Related Resource Links

SharePoint's Sandbox: Developing, Deploying and Monitoring Sandboxed Solutions in SharePoint 2010


The challenge in SharePoint development has always been the balance between creating and deploying solutions that you can trust not to damage or impair a SharePoint farm. A new feature in SharePoint 2010, called Sandboxed Solutions, enables farm administrators to feel comfortable that the SharePoint farm is safe, gives site collection administrators the authority to manage applications in their site collection, and provides developers with the flexibility to create solutions they know will be deployed in a safe and rapid manner.

Paul Stubbs

MSDN Magazine November 2009

Data Points: Disabling Constraints and Triggers


What to do when you need to disable triggers and constraints to perform data synchronization and other tasks with an offline database.

John Papa

MSDN Magazine April 2007

Design Patterns: Simplify Distributed System Design Using the Command Pattern, MSMQ, and .NET


Service-oriented architecture is a great framework when you need to perform distributed computing tasks over the Internet. But when you want to perform processing inside your local network, a different solution may provide a better fit. That solution, based on the Command pattern, uses Windows services and Microsoft Message Queuing to implement a queued system that meets your needs better than a service-oriented solution. This article explains how to build it.

Brad King

MSDN Magazine September 2004

C++ Q&A: Performance Monitoring, Managed Extensions, and Lock Toolbars


In the June 2004 issue of MSDN®Magazine, I described a class called ShowTime that you can use to do simple performance monitoring for your app. ShowTime uses its constructor/destructor to record the start/stop times of its existence so you can instantiate it in a block of code like so: { ShowTime st(_T("Total time is:")); // some lengthy operation } .

Paul DiLascia

MSDN Magazine September 2004

MSMQ and .NET: Send MSMQ Messages Securely Across the Internet with HTTP and SOAP


When creating a distributed system you frequently need to provide for communication between two entities that are not in sync. Microsoft Message Queue Server (MSMQ) provides the kind of store-and-forward messaging in a pre-built infrastructure that can help you address these kinds of messaging needs. In the past, MSMQ was accessed using a COM wrapper. Now there's a .NET wrapper that lets you accomplish your messaging goals easily from your Framework-based code. To illustrate the use of the wrapper, the author builds a messaging application, sends MSMQ messages over the Web, and discusses messaging security.

David S. Platt

MSDN Magazine December 2003

Pocket PC: MSMQ for Windows CE Brings Advanced Windows Messaging to Embedded Devices


Handheld devices are becoming increasingly important nodes on wireless networks, allowing their users to connect to data stores and other central server applications over the network. But wireless network connections can be unreliable, requiring the use of store-and-forward messaging that does not need to maintain a continuous connection. Microsoft Message Queue (MSMQ) has supplied these features to desktop machines, and there is now a version for handheld devices. MSMQ for Windows CE allows users of embedded devices to perform tasks such as remote order processing and inventory update without worrying about the state of their connection. The benefits of MSMQ for Windows CE and how to install and run the service is covered here.

Bob Hartman

MSDN Magazine December 2001

MSMQ Remote Queueing

Hi All, My application is about message queuing. I have a problem checking the existence of a queue in the public/private queue in the remote server (win2003), my client is running Vista Business. I already set full control to everyone,etc in the message queueing in the server. Client is in the server's domain. Here's the code public MessageQueue(string queuePath, bool transactional)         {             try             {                 this.queuePath = queuePath;                 queue = new System.Messaging.MessageQueue(queuePath);  //UnsupportedFormatNameException in this line                 if (!(System.Messaging.MessageQueue.Exists(queue.Path)))                     System.Messaging.MessageQueue.Create(queue.Path, transactional);                               &nbs

Can I use TCP sockets within managed funcs, triggers and stored procedures?

I have seen nothing prohibiting this, but have not yet had time to write some test code. Does anyone know for sure if SQL Server 2008 prohibits or allows TCP sockets for communications, inside a C# SQL/CLR function or method? I guess it must because this is implict when creating data connections and so on, which are obvioulsy allowed. Thanks Cap'n  

I have 3 triggers defined on an sqlserver2008 table and I can't find them with c#

I've got the code below and when I run it, it always says there are 0 triggers in table.Triggers.  I added some debugging code checkin the table.HasDeleteTrigger, etc. and from that, I get the exception: "To accomplish this action, set property HasDeleteTrigger." when I try to set it to bool hasDeleteTrigger. I can get stored procedures find, just not triggers. Below is my problem code: foreach (Database database in databaseCollection) { if (database.Name.Equals(catalogName)) { // first we need to delete triggers associated with all tables that begin // with our prefix. we can skip our the framework tables because those // don't have triggers on them // grab all tables, filter for non prefixed ones in foreach loop so we can delete triggers from non prefixed ones results.AddRange(from Table table in database.Tables select table.Name); foreach (var tableName in results) { var table = new Table(database, tableName, CrSyncDbSchemaName); table.Refresh(); bool hasDeleteTrigger = table.HasDeleteTrigger; bool hasAfterTrigger = table.HasAfterTrigger; bool hasInsertTrigger = table.HasInsertTrigger;



Performance monitoring and baselining

Hello, While collecting the baseline data through perfmon I had come across few basic doubts in my mind which I need to clarify with your help. Suppose we have lot of RAM available and we launch an application (say a huge SSRS report with 5 million records). This takes up all the RAM and we see a steep decline in the perfmon chart. Once this report is generated , we notice a rise in the available memory. Does this means, the memory is released automatically by the report server? What is the concept behind this? Can we forcefully make SQL Server (or report server) to release the acquired memory at any point of time? Regards.

Triggers when Log-Shipping is used

When we restore a db using Log-shipping, do the triggers in the destination db get fired from the changes occured in the shipped log? I guess the answer is negative but just want to make sure I am not missing anything. Thanks in Advance.  

MSMQ Access Issue

I am trying to access a private queue through WCF from a windows service. If i make the windows service run under the context of my domain user account, WCF is able to access the queue, however if i make it run under local system/ Network Service WCF is unable to access the MSMQ. I tried giving full access to everyone and also to network service. Can anyone help? Thanks for ur time
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend