Identify Blocked SQL Processes Quickly: Figure 2 Select Records from the Table.

The SQL code used in the blocking example starts selecting records from the tblCountry table, while a pending transaction exists against the same table. The status on the bottom left-hand side of the window says "Executing query … " The query cannot obtain the records because of the previously created transaction.

Identify Blocked  SQL Processes Quickly: Figure 2 Select Records from the Table.
comments powered by Disqus
Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.