0

I have a strange situation. I'm working on a SQL Server 2005 database, I've searched locks on DB using this.

After capture all day, stop the trace and see the results, I found a blocking query that blocks a insertion, BUT, the query is in read committed isolation and read table A, the insertion try to insert on table B with all values defined.

Anyone knows why the first query is blocking the second one?

I've searched all dependencies on the two tables and haven't found any.

I know that this could be solved changing the isolation level of the select statement, but I want to know why this occurs

Thanks!

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Mariano G
  • 255
  • 4
  • 14
  • Have you also checked the triggers as well as the functions? – Hozikimaru Nov 23 '14 at 05:42
  • Yes, the Table B (insert), has 3 triggers, one for Insert, but only updates the same table. I checked on "View Dependencies" for each table and nothing there too. – Mariano G Nov 23 '14 at 13:49

0 Answers0