Apr 8, 2013 · I am developing a web-app using both WebSQL and IndexedDB. IndexedDB works well in browsers that support it, and my WebSQL implementation works in most browsers, …

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) …

On the server where the trigger resides, you need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > …

In plain English, what are the disadvantages and advantages of using SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in a query for .NET applications and reporting …

I understand how a transaction might be useful for co-ordinating a pair of updates. What I don't understand is wrapping single statements in transactions, which is 90% of what I've ever seen. …

Add column to table and then update it inside transaction Asked 14 years, 10 months ago Modified 9 years ago Viewed 96k times

I have this open transaction, according to DBCC OPENTRAN: Oldest active transaction: SPID (server process ID) : 54 UID (user ID) : -1 Name : UPDATE LSN ...

I do not have any t-sql transaction code in any of my stored procedures. In theory, the transaction should be controlled by the MyAddUpdateMethod ()

The JTA starts and commits your transaction. If you use application managed EntityManager and you don't want to be in part of JTA transaction, then you need to manage them for yourself (it's …

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...