Posted by Erland Sommarskog on 09/29/07 16:13

Dimitri Furman (dfurman@cloud99.net) writes:
> On Sep 28 2007, 05:42 pm, Erland Sommarskog <esquel@sommarskog.se> wrote
> in news:Xns99B9F1E3FC5AEYazorman@127.0.0.1:
>
>> By the way, I tried the repro on the July CTP of SQL 2008, and the error
>> does not occur there, but the procedure completes successfully.
>
> I hope it does not mean that they won't bother fixing it in 2005...

I could be that it's fixed in Katmai "by accident", but it could also
be the case that the issue is known, but the fix is deemed to risky to
implement in SQL 2005.

I found this KB Article: http://support.microsoft.com/kb/923605, but this
appears to relate to a fix for SP1. Nevertheless, the Symptoms section
says "This problem occurs if table variables are used in a transaction."


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

[Back to original message]