Server failed to resume the transaction

  • Thread starter Thread starter Roman
  • Start date Start date
R

Roman

Hello,

I am using a .Net 2.0 service for updating data on SQL Server 2005. for
the updatin data i created several parametrized stored procedures.
There is no explicit transaction logic defined in the code or in the
stored procedures (C# using SQLConnection and SQLCommand). Sometimes
when the sql command is executed this error occurs:

-- start Error Log
Event Type: Error
Event Source: LTTV5
Event Category: None
Event ID: 0
Date: 25/01/2007
Time: 11:37:50
User: N/A
Computer: SRMGPA12
Description:
An error occurred in .Net SqlClient Data Provider the error message is
Server failed to resume the transaction, desc: 5300000002.
The transaction active in this session has been committed or aborted by
another session.The following additional information is available:
HelpLink.ProdName: Microsoft SQL Server
HelpLink.ProdVer: 09.00.1399
HelpLink.EvtSrc: MSSQLServer
HelpLink.EvtID: 3971
HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink
HelpLink.LinkId: 20476
Source: .Net SqlClient Data Provider
Location: at
InfoResearchBern.LTT.Backend.DBA.CLTTdbUpdateJob.UpdateJob(CLTT_JobData
JD)


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
-- end Error Log

If I restart the service and produce exactly the same statment
eyerything works. I also tried to execute the SP directly in SQL Server
Management studio during the service fails it work without problems...

Any idea what's happening?
 
Back
Top