How I post a message on MSMQ?

Hi,
I want to execute a T-SQL for adding a message on a message queue, I know
that I can create a DTS task but I want to include it on a trigger. I found
extended procedures like xp_createprivatequeue and so on but no procedure to
push a message, Also I know that I can create my own xp to do it but I was
wondering if there is a simpler way,
thanks!
Salva
Salvador Alvarez Patuel
salvador.alvarez@.exony.com
Exony Ltd - London, UKHi
That is an undocumented XP and you should not use it.
SQL Server has no built-in methods to acces MSMQ. That belongs in a
middle-tier or your application.
Regards
Mike
"Salvador" wrote:

> Hi,
> I want to execute a T-SQL for adding a message on a message queue, I know
> that I can create a DTS task but I want to include it on a trigger. I foun
d
> extended procedures like xp_createprivatequeue and so on but no procedure
to
> push a message, Also I know that I can create my own xp to do it but I was
> wondering if there is a simpler way,
> thanks!
> Salva
> --
> Salvador Alvarez Patuel
> salvador.alvarez@.exony.com
> Exony Ltd - London, UK