Post reply

Extended Stored Proc to send in MSMQ

  • December 16, 2003 at 7:51 am

    #161004

    Hi

    I was wandering if anybody ever build an extended SP (SQL2000) to send a transaction to MSMQ3.

    (I never built any myself)

    I did solve the problem by creating a DLL in vb6 but I'm sure it can be done directly in SQL ...

    Anybody up to the challlenge ?

    Parameter : QueuePath varchar(150) , Priority varchar(3) , Label Varchar(50) , Body Varchar(5000)

  • December 16, 2003 at 8:00 am

    #486407

    Please cancel this request , I did found it .

    http://www.sqlservercentral.com/products/xp_msmq/#download

    Thanks

  • December 16, 2003 at 8:03 am

    #486408

    What's the Problem with the Message Queue Task within DTS?

    is it not good for your purposes?


    * Noel

  • December 16, 2003 at 8:56 am

    #486422

    Sincerely , I don't know .

    I usually use DTS as last resource in transactional process , or for task not affected by performance .

    a co-worker had built something that was a nightmare of maintenance and scalability near to none, I looked at it and proposed to do MSMQ from SQL directly, So I had to come up with something and gone with what I knew would work for sure.

    Thanks for the idea , I'll investigate this a little later.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply