HOW TO SAP - CHECK ACTIVE MS SQL TRANSACTION

Log files grow and unable to shrink even after backup.





  1. Launch MS SQL Server Mananagement Studio
  2. Execute SQL command > DBCC OPENTRAN
  3. You will get below result. You notice the SPID is 76


  4. Go > Management > Activity Monitor

  5. Now you find your SPID running

  6. Just right click and kill the SPID. It might take more then 1 hour before the process is killed/rollback

Popular posts from this blog

HOW TO SAP - Create RFC TCPIP connection and Register Server Program with RFCEXEC

Step by step to create new job using SM36

HOW TO SAP - SAP Web dispatcher Installation