How to Find Blocking Queries in Transaction In SQL server?

Sql Server By Sagar Jaybhay

In this article, we will learn Blocking Queries In Transaction and Except Operator and difference between Except and Not In Operator in SQL Server By Sagar Jaybhay. Blocking Queries Blocking Query happens because there is an open transaction. DBCC OpenTran is a command for checking the open transaction but there is a problem it only shows the oldest active transaction. It is not going to show you an open transaction. We write a transaction and execute that and run dbcc opentran command see below image Below is a query which…

Read More