Hi Team,
I want to send all the query plan to the JMS queue along with change in data. This is for the wiretapping purpose.
I would like to know if there is any standard solution available to do the same.
Regards,
Sanjay
Hi Team,
I want to send all the query plan to the JMS queue along with change in data. This is for the wiretapping purpose.
I would like to know if there is any standard solution available to do the same.
Regards,
Sanjay
Please check if below link could help you.
Posting Message to MSMQ from SQL Server
Best regards,
Cathy
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thanks for the reply. I looked at the link but i am not 100% clear. Once we create a stored procedure which will call a MSMQ to send the messages. How can i make it real time and keep it running 24x7? Is this stored procedure will be called before executing any of the query on the SQL server?
Appreciate your help!
3 people are following this question.