Concurrency Issue with Temp Tables in Snapshot Isolation Level - by Loris Chiocca, Infonic AG

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 777261 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/23/2013 7:40:46 AM
Access Restriction Public

Description

Creating a temp table in a snapshot isolation level transaction causes concurrency issues.
Sign in to post a comment.
Posted by Microsoft on 5/6/2014 at 11:44 AM
Thanks for reporting this issue. It longer reproduces in SQL Server 2012 or later versions.

Sincerely,
Ajay.
Posted by Loris Chiocca, Infonic AG on 4/30/2013 at 5:32 AM
Hi Gus,

In your last post, you state that you need additional details from my side. Could you elaborate on this? What exactly would you additonally require? Should I upload a database with the scripts attached to this issue? If you wish I can create a web-ex and demonstrate it. I'll be glad to help in any way I can

Regards
Loris
Posted by Microsoft on 4/29/2013 at 2:35 PM
Hello,

Thank you for submitting this feedback. Unfortunately the description is not detailed enough, and we need more information from the customer. Resolving back to the customer for more details.

Thanks again for reporting the product issue and continued support in improving our product.
Gus Apostol, SQL Server Program Manager
Posted by Microsoft on 4/29/2013 at 2:34 PM
Hello,

Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing this bug is because the scenario reported in the bug are not common enough and due to the risk of implementing a fix it unfortunately does not meet the bar for the current version of the product.

If you have more supporting information and details or feel strongly that we should reconsider, please do resubmit this item for review.

Thanks again for reporting the product issue and continued support in improving our product.
Gus Apostol, SQL Server Program Manager