Just curious, are you running the MSDTC on both servers? This allows transactions to be distributed among servers.

>I have two servers running SQl2000, with two databases. Each database is related to an distinct aplication.
>
>When i tried two update/delete/insert some data in a table in server 1 a trigger is fired, to modify data in the other server.
>
>My problem is when this happens, the server where the trigger was fired, returns the message "Cannot start more transactions on this session".
>
>The two applications are independent, and the only connections that exists between then are the triggers.
>
>I've checked the configuration (linked servers) of the two servers, and all seems right.
>
>I thank you in advance
>
>Mário Rêlha