Im using sp_getbindtoken and sp_bindtoken to get and set transaction bind tokens of several concurrent transactions in order to get rid of some annoying deadlocking issues.
I share the bind tokens of the current transactions in a global variable, but my solution is vulnerable for system crashes, because the finishing transaction code fails to remove the bind token from the global variable, hence leading to this error when calling sp_bindtoken with a bind token that is no longer valid:
'Cannot enlist in the transaction because the transaction does not exist.'
Is there any way of retreiving a list of the current transaction bind tokens? I'd like to validate my bind tokens before I call sp_bindtoken...