Morning;

The horse appears to be the same colour. 😉

I didn't check the @@version someone else did; would appear that we do not have CU6 for SP2 so this bug is...

The reason I'm asking is I appear to have the correct cumulative fix applied and I just got a deadlock on a temp. table... :crying:

Hello;

Thanks for your reply, but I don't believe the cause in the article is clear.

This issue occurs because the two sessions that are used to execute the stored procedure...

Hello;

Can anyone explain this issue in any more detail? Is it just an issue with Lock Manager or is it an issue with tempDB.

I cannot believe that there is an...

Yes - that was always my impression too. However, I have seen a deadlock occur on a temp resource:

<objectlock lockPartition="6" objid="-1602335561" subresource="FULL" dbid="6" objectname="tempdb.dbo.#LogTab______..."

Microsoft confirm this behaviour: https://support.microsoft.com/en-gb/kb/2776344

I've...

Hello;

I know this thread is a little old, but I've seen a deadlock on temporary tables - this was due to Lock Partitioning. I think this issue was "introduced" since...