Post reply

what happens to transaction when memory in sufficiant error comes.

  • June 28, 2016 at 4:13 am

    #400334

    hi,

    i am getting memory in sufficient error in my querywindow. ( i am planning to increase) but

    i have one snapshot transaction which is used to transfer data.

    so i started thinking ,what might happen if this error comes while transaction is running , is there any way to rollback.

    and i want to know what happens to transactions, when this error comes.

    yours sincelrey

    <html:div data-url="https://social.msdn.microsoft.com/Forums/en-US/newthread?category=sqlserver&forum=transactsql" id="link64_adl_tabid" style="display:none;">47</html:div>

  • June 28, 2016 at 4:45 am

    #1887230

    What's the exact error message?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 28, 2016 at 6:39 am

    #1887257

    Without seeing the error, it's hard to say. However, if you start a transaction and that transaction fails, you will get a rollback of that transaction.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply