question

SanjayHingu-0945 avatar image
0 Votes"
SanjayHingu-0945 asked SanjayHingu-0945 commented

Microsoft SQL Send query plan to MSMQ

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

any help team?

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered SanjayHingu-0945 commented

Hi @SanjayHingu-0945,

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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!

0 Votes 0 ·