Stored Procedure Initiated Call Outs

Stored Procedure Initiated Call Outs

Post by Damian Joll » Tue, 19 Dec 2000 09:56:05



In designing a three tier solution, I am assessing methods of communication from
SQL Server 7 to Application Server, initiated by triggers.

Automation
Call outs to a COM Server appear to be the only option that I have read, and it
is suggested that there are limitations to this.   (sp_OACreate/sp_OAMethod are
slow and serialized).

Can anyone suggest other methods?

Thank you.

Damian Jolly