Christianto Tjahyadi wrote:

> Btw, how to know the current (active) isolation level used? Also, how to set
> the deadlock time out?

Maybe you could find this in your connection component.
E.g. IBO's TIB_Transaction has a property named "Isolation" - which shows
just that for this transaction. Other transactions may have been set up
differently.
If you want to know this inside an SP - tough luck.

Don't know a thing about "deadlock time out".


--
Aage J.