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_pss80 sp_blocker_pss80 or other tools to find other real locking...

Just in case anyone needs the answer, the trick is to add the EventClass Event to SQL profile , and filter on the following Events:

RPC:Completed

SP:StmtCompleted

and you will see the raw...

We are also hitting this problem, and AWE is not enabled.

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...