Hello ,
I need to use queue mechanism . I have read some articles about msmq . It seems that I have to send data to msmq from sql by using triggers when a data is inserted to sql table an insert trigger pushes the data to msmq. Lets assume that I have stopped msmq service for a minute. At that time I have inserted data to sql table. As you guess the insert triggers will not be able to push messages to msmq service. I have to trigger manually messages to push msmq when service starts to work. Isn't msmq able to pull data from sql table by itself ? By a mechanism like this , even msmq goes down , it can continue to get the data that hasn't been inserted to queue .
Thanks...