How to get SQL Server Explicit Permssions for a Server Principal

Query sql server explicit permissions list Read more →

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 →

How to find privilege changes with SQL Server Default Trace

How to check sql server security privilege changes using default trace ? Read more →

sys.dm_server_services - How to check if SQL Server service is running or not?

How to check if SQL Server service is running or not?How to get service account details in SQL Server? Read more →