In SQL Server Profiler you see that a transaction starts and one line below it fails but I have no clue why the transaction fails.
The transaction was initiated by a C# program using a table adapter and LINQ. In Visual Studio you see that the transcation fails but not why it fails.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.