Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Using the Blocked Process Report in SQL Server 2005/2008 RE: Using the Blocked Process Report in SQL Server 2005/2008
don.schaeffer
Ten Centuries
Points: 1195
More actions
April 9, 2010 at 3:45 pm
#1149403
If there are transactions involved locks may be retained on tables from previous statements. Even though the second spid might be selecting from table b it may still have a lock of some sort on table a if this is wrapped within a transaction.