In designing a three tier solution, I am assessing methods of communication from
SQL Server 7 to Application Server, initiated by triggers.
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?