This SqlTransaction has completed

Data Abstract
1

Hi,

I have an application that was working. I had to change the seed values on my SQL Server IDENTITY columns. Now, when I try to insert a new row, I get the following error: “An exception was raised on the server: This SqlTransaction has completed; It is no longer usable.” Some of the comments that I found suggested shared connections. I am using DA SQL with RS, in a Delphi EXE. Has anyone else experienced this or have an idea where I should look?

Thanks,

David

2

Some more information:

  1. I am inserting into a view.
  2. I added a computed column to the underlying table that calculates the value based on a UDF. However, this column is not in the above view. I can select against the table and there are no problems with the column.
3

I found the issue. I had a problem with a trigger.