why am getting error like 'can't write to log file' while deleting from table using trigger?

Question

0.00/5 (No votes)

See more:

Hi,

I am deleting data from one table using trigger but getting error like in below

Line 129
The current transaction cannot be committed and cannot support
operations that write to the log file. Roll back the transaction.
The statement has been terminated.

Please help me why i am getting this error.

Posted 17-Jan-16 18:30pm

Member 11337367

Add a Solution

Comments

Sahan2u 18-Jan-16 2:04am

Do you have a TRY/CATCH block ?

Member 11337367 18-Jan-16 2:05am

s.we have.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sahan2u · Answer 1 · 2016-01-17T20:19:00

Solution 1

You always need to check for XACT_STATE(), irrelevant of the XACT_ABORT setting.

Refer the following link which has a good answer for this.

sql server - SQL Transaction Error: The current transaction cannot be committed and cannot support operations that write to the log file - Stack Overflow[^]

Posted 17-Jan-16 20:19pm

Sahan2u

Comments

Member 11337367 18-Jan-16 2:26am

directly i can use in trigger?

Sahan2u 18-Jan-16 2:39am

Yes you can.

Member 11337367 18-Jan-16 2:46am

what is the use of having that command in sp?

Sahan2u 18-Jan-16 3:53am

Read the answers given to that question. For more information you can also read the answers here.

http://stackoverflow.com/questions/15980318/trigger-error-the-current-transaction-cannot-be-committed-and-cannot-support-op

it has bit more description.