Breaking News: Grepper is joining You.com. Read the official announcement!

add solution on grepper

man_kush answered on May 17, 2023 Popularity 2/10 Helpfulness 1/10

answer add solution on grepper

add solution on grepper

Comment

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

if transaction is in uncommitable state and we tried to commit that transaction. we got this kind of error.
Example:
CREATE TABLE tbl 
(
ID INT IDENTITY(1,1) PRIMARY KEY, 
Age INT CHECK (Age >18)
);

SET XACT_ABORT ON ;

BEGIN TRY
  BEGIN TRANSACTION
   	INSERT INTO tbl VALUES (17) 
  	INSERT INTO tbl VALUES (28)
  	COMMIT TRANSACTION
  
END TRY

BEGIN CATCH
	print XACT_STATE() -- xact_state = (-1) indictae that the transaction is uncommitable.
	commit -- this will happen as part of the catch block, this will cause the exception of error 3930 to happen
	
END CATCH;

SET XACT_ABORT OFF ;
GO

Popularity 2/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: add solution sql

Link to this answer
Share Copy Link

Contributed on May 17 2023

man_kush

0 Answers Avg Quality 2/10

add solution on grepper

Contents

More Related Answers

add solution on grepper

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.