We have been using Embarcedro ER/Studio ( I have been told that this has the basic components as Change Manager) for producting upgrade script , and the method of creating...
Yes I had seen other entries uising google , but I can see this behaviour causing more headaches and red herrings/false alarms when using sp_blocker_pss80sp_blocker_pss80 or other tools to find other real locking...
We are trailling SP4 on a test server and we are noticing SELECT queries are being blocked by themselves. I have found a couple of other people having this problem...