• Thus, you got a good incentive to reconsider your solution.

    I recommend writing a CLR stored procedeure instead of using sp_OAxxxxx.

    But you should not make SOAP requests inside a trigger. In a trigger you should do actions that are atomically part of the statement. That is, if the action fails, the statement fails. If the remote host to which you SOAP requests is down, should the statement that fired your trigger fail?

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]