Posted by Erland Sommarskog on 09/12/07 22:08

Sputnik (id_hannah@hotmail.com) writes:
> We are running a query in SQL Server 2005 that makes use of temporary
> tables and table variables. Occassionally a call to this query locks
> up and subsequent calls timeout. The only way to get out of this is to
> restart SQL Server which is a real pain.
>...
> 2007-09-12 11:43:53.23 spid4s Deadlock monitor failed to resolve
> this deadlock.
> Server may require restart to recover from this condition

Looks bad.

This is definitely a bug in SQL Server, and I would recommend that you
open a case with Microsoft so that they can analyse it.

I know that there are some bugs around handling of temp tables and table
variables that have been fixed post-SP2, but it could also be something
else.

Note that while MS may charge you initially when you open the case, once
they have confirmed that it is a bug, you should be refunded.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: simple OUTER JOIN (I thought)
• Prev in forum: Re: strange error: ran out of internal resources
• Thread view: Re: Deadlock in SQL Server 2005 sp2 running queries using temp tables or table variables

[Reply to this message]