Does anyone know of any way to list open transactions on SQL Server 2000 database? I am aware that I can query the view sys.dm_tran_session_transactions on SQL 2005 (and later) database versions,

Could not commit JPA transaction: Transaction marked as rollbackOnly This exception occurs when you invoke nested methods/services also marked as @Transactional.

I have a long running process that holds open a transaction for the full duration. I have no control over the way this is executed. Because a transaction is held open for the full duration, whe...

mysql> update customer set account_import_id = 1; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction I'm not using a transaction, so why would I be getting this error? I …

There is an Update query in progress, the Transaction is started at a higher level on the connection. In order to ensure that all server data is in a valid state for the Update, I need to do a couple reads.

Does anyone know the command to check if there is an un-committed transaction in SQL Server 2005?

Sometimes I get this kind of exception on not very busy SQL server: Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Re...

BEGIN TRANSACTION / COMMIT "extends" this locking functionality to the work done by multiple statements, but it adds nothing to single statements. However, the database transaction log is …

optimistic locking consists in detecting that another transaction has updated/deleted the same row, and throwing the exception you're getting in this case. If you have a version field, you're already using …

The alternative is an ambient transaction; new in .NET 2.0, the TransactionScope object (System.Transactions.dll) allows use over a range of operations (suitable providers will automatically …