How to write and read data into queue from Trigger

Question

I have plan to store newly inserted / updated data into queue from trigger. so please tell me how could i store inserted / updated data into queue from trigger. a small example of code will help.

How to read data from sql server queue from c# console application. basically ?

How to show data stored in queue from SSMS?

Thanks

Answer 1

To be able to send a command on a Service Broker queue, you first need to start a dialog with BEGIN DIALOG. Although in most cases you would work with pooled connections, and get a pooled conversation handle from a table, if it is available. Once you have the handle, you use the SEND command to send the message. On the other end you use the RECEIVE command.

This forum is good for short and simple questions, but it is not a good venue to learn features from scratch. You have had threads in the past where I and others have suggested reading material about Service Broker, and I suggest that you revisit those threads.

Answer 2

Sir i want to store data into service broker queue from trigger. How it will be possible?

How to store data into queue from table and how to read data from queue?

Thanks