Find open transactions

Is there an easy way (SQL Query or enterprise manager) to see if there is an open transaction pending?

yes, you can look into Management Activity monitor.
I do not know why you need this but remember that transaction is active as long as connection is active so if you look for not finalized transaction which were done in dropped connection it probably will not work.
I am not 100% sure about this but I found it somewhere.

Thanks

|||

I missed it when I looked before. FYI, I needed the information because I was debugging a long script that for some reason wasn't executing the statements after a certain line. I thought it might have been due to a transaction not being closed. But it was bad data preventing a unique index from being created.

Thanks for the answer.