We are planning a migration from SQL Server 2005 to SQL Server 2008 R2, but it seems that the Bug #: 50002514 (http://support.microsoft.com/kb/949687/en-us) was not fixed in 2008 R2.
My test configuration:
- Windows 2008 R2 Server, Standard 64 bit (7600)
- Sql 2008 R2 Server Developer Edition 32 bit (10.50.1600.1), two instances (A and B) installed and linked ( A->B and A<-B).
Our software reports an error from SQL Server 2008 R2: "(3970) This operation conflicts with another pending operation on this transaction. The operation failed." On another test system with the same software using SQL Server 2005 SP3 (32-Bit)/Windows
Server 2008 R2 everything works just fine.
Is anything wrong with my configuration (64/32-bits mixup) or this problem is related to SQL Server 2008 R2 itself and therefore it can be fixed sooner or later?
View Complete Post