Changes between Version 15 and Version 16 of HowTo

Show
Ignore:
Timestamp:
10/01/08 13:26:22 (2 years ago)
Author:
jack
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • HowTo

    v15 v16  
    202202where ''text'' is the XML payload  
    203203 
    204 ==== Programmatic Example ==== 
     204== Programmatic Example == 
    205205 
    206206Here is a trivial sample C# code snippet which illustrates how to receive trigger messages from sql2msmq 
    … …  
    263263}}} 
    264264 
    265 ==== Caveats ==== 
     265== Caveats == 
    266266 
    267267Don't leave triggers associated with message queues that you are not monitoring.  Failure to perform destructive reads or purges on messages in the queue may lead to reduced server performance, or ultimately more severe resource errors which may ultimately result in your server being unavailable or even crashing.  MSMQ allows limits to queue size to be set; it is essential that you understand the impact of accumulating messages on the queue. 
    268268 
    269 == Trivial solution ==  
     269=== Trivial solution === 
    270270Unregister the Sql2msmq assembly trigger when no readers are operational.