The “type” column indicates whether the transaction is local, remote, or external. Local transactions execute on the local server (the server on which you ran sp_transactions). Local transactions have a null value in the “srvname” column, since the transaction takes place on the current server.
For remote transactions, sp_transactions lists the name of the server executing the transaction under the “srvname” column. The sp_transactions output above shows a remote transaction executing on the server named caserv2.
External transactions indicate that the transaction is coordinated by an external transaction coordinator, such as CICS, Encina, or the “ASTC HANDLER” process of another Adaptive Server. External transactions also have a null value in the “srvname” column.
