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

Feb 21, 2014 · Exec USPStoredProcName I get the following error: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current …

May 23, 2014 · Msg 9002, Level 17, State 4, Line 1 The transaction log for database 'MyDb' is full due to 'ACTIVE_TRANSACTION'. and it did not delete a thing. What does that message mean? How can I …

Jul 27, 2013 · Imagine the following scenario: I am using SQL Server 2005. I have a transaction that is calling, among other SQL statements, a stored procedure that also has a transaction inside. The …

Feb 22, 2013 · The good news is a transaction in SQL Server can span multiple batches (each exec is treated as a separate batch.) You can wrap your EXEC statements in a BEGIN TRANSACTION and …

Apr 14, 2012 · Add a try/catch block, if the transaction succeeds it will commit the changes, if the transaction fails the transaction is rolled back:

Apr 27, 2017 · 14 If one of the inserts fail, or any part of the command fails, does SQL server roll back the transaction? If it does not rollback, do I have to send a second command to roll it back?

Jul 18, 2014 · 12 You cannot use Set Transaction Isolation Level Read Uncommitted in a View (you can only have one script in there in fact), so you would have to use (nolock) if dirty rows should be included.

Apr 22, 2021 · A larger transaction log file in itself if not detrimental to performance as SQL server writes to the log sequentially, so provided you are managing your overall log size and allocation of …

Apr 6, 2017 · Do u think there is a better way to write a transaction in t-sql? Is there a better approach that improves maintainability and performance of the application that uses this transaction? -- Descri...