Send MSMQ message from SQL Server

2007-05-03 08:19:19 by Kjell-Åke Gafvelin

I got a question from a customer if there was any solution to send a message via MSMQ from SQL Server. After some searching I found two different solutions to the problem. The first solution is to install a extended procedure (XP_MSMQ) and the second is to modify the security settings for System.Messaging and use the CLR integration in SQL Server.