Question: I've suddeny started getting this error message in an ETL process via a SQL Server - stored procedure. How can I troubleshoot ? I'm looking for a way to report the errors just before this errror message - and get some clues to fix the issue. Msg 3930, Level 16, State 1, Line 17 The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction. Answer: As a general approach this error occurs when a) the TRY..CATCH BLOCK is used . b) There is an issue with the transaction ,...
Read more →