>>> Okay, we need to figure out how to do an Out of Process dll. Can someone point me in the direction that I can find out how to do Out of Process Dlls?
>>>
>>Build an Exe, run it to get a process, host the dll's therein, get an interface and call away...
>>Or: what is your definition of process / Out of process ?
>
>The definition as we know and need:
> in process called from a trigger locks up the sql server and the server must be restarted if something goes wrong. out of process has it's own space and when something happens we would simply have to kill the process not restart sql server. I am quite sure the DBA's would not be happy with restarting the sql server every time some little problem occurs with this function.

As the broad definition of Dll's is "runs in process" the original question is hard to answer if considered verbatim<g>. My workaround seems to fit: create an exe to host and call the dlls within. This Exe is free for killing without touching your server's core running - you still need errorchecking/rollback on all calls working in the killed Exe-Dll's.

HTH

thomas