Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Can you reverse an UPDATE command in SQL

    Posted Tue January 18, 2022 09:59 AM

    Hello,

     

    I did an UPDATE command in our TEST Maximo DB in SQL Server Management Studio and accidentally updated records. Is there a way to reverse this command?

     

     

     

     

         DisneyWorld.com/50

     

     

     

     



    Senior Maximo Specialist, Reedy Creek Energy Services
    Email: Chelsea.R.McCabe@Disney.com
    Cell: (407) 701-4239

    Work Schedule: Mon-Fri 7:00-16:00 (effective 1/3/2022)

     

    Maximo Inquiries, please submit a Service Request in Maximo: Click Here

     

    "How-To" Submit a SR Document: How To Create SR in Maximo

     

     


    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Can you reverse an UPDATE command in SQL

    Posted Wed January 19, 2022 02:13 AM
    Usually not Chelsea.  SQL Server normally has implicit commit set so unless you started your update statement with a "begin transaction", I doubt you'd be unable to undo it.  Being a Test system hopefully you can get it refreshed from your production system and you can try again.

    Regards,
    Scott Taylor

    ------------------------------
    Scott Taylor
    Specialist Business Systems
    Port Waratah Coal Services
    ------------------------------

    Original Message


Related Content