How to use Extended Events to report Query errors

How to use Extended Events to report errors and monitor errors with SQL Server Extended Events Read more →

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

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 →

Sql certificate chain was issued by an authority that is not trusted

How to solve the certificate chain was issued by an authority that is not trusted? Why the certificate chain was issued by an authority that is not trusted? Read more →

Trace flag 902 in SQL Server and Error 574

What is Trace Flag t902?How to check trace flag in SQL Server? Read more →

Tcp port is already in use.How do I check if a port is already in use?

how do I check if a port is already in use? Read more →