Hi, I'm getting this error occasionally in a production environment:

Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver]Exception generated during defered local transaction handling.
See next exception via SQLException.getNextException for details.

I don't get this error in environments other than production, and I'm
able to run the SQL query in SQL Server.

I don't see the next exception or any more details about this error.
Does anyone know how to access SQLException.getNextException in
ColdFusion to see more details about this error? or any other
suggestions to debug this problem?

Thanks in advance.

ColdFusion MX 6.1 with updater
SQL Server (version 8)