You must Sign In to post a response.
  • Category: SQL Server

    The transaction associated with the current connection has completed but has not been disp

    I have received the below error, after deployed the new sql deliverables from the application.
    Can anyone answer to resolve this issue?


    The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements
  • #765080
    This happen when the transaction times out. You can increase the timeout for your transaction like this (use values appropriate for the expected length of your transaction)
    you may use below code in C#
    using (TransactionScope scope =
    new TransactionScope(TransactionScopeOption.Required,
    new System.TimeSpan(0, 15, 0)))
    {
    // working code here
    }

    use a 'TimeSpan' class, with the specified timeout in minutes

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #765082
    Thank you for your response.


Sign In to post your comments