Transaction is complete error message? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transaction is complete error message?

SQL Server 2000 I was running a bunch of statements. Each one called an object which created a connection object, created a transaction object, inserted a record, destroyed everything (.NET object using native SQL provider). In the middle of my inserts, I got a message "Transaction is complete, it is no longer usable". What could have caused this? After I clicked okay, my job continued. Each save calls an object which in turn uses a new connection and transaction object so how would the transaction have failed? I figured it might have something to do with the log file but couldn’t imagine what. Thanks
Cody
Any information on SQL error log or event viewer? Try to monitor the activity with PROFILER, if possible. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>