![Query to Find and Kill Long Running Transactions in SQL Server 2008 R2 or 2012 | Chaya - Digital Zen Query to Find and Kill Long Running Transactions in SQL Server 2008 R2 or 2012 | Chaya - Digital Zen](https://chayadigital.files.wordpress.com/2014/09/image2.png)
Query to Find and Kill Long Running Transactions in SQL Server 2008 R2 or 2012 | Chaya - Digital Zen
![sql server - What happens to an open transaction when the session window is closed? - Database Administrators Stack Exchange sql server - What happens to an open transaction when the session window is closed? - Database Administrators Stack Exchange](https://i.stack.imgur.com/HEHmF.png)
sql server - What happens to an open transaction when the session window is closed? - Database Administrators Stack Exchange
![How to prevent accidental data loss from executing a query in SQL Server aka “Practicing safe coding” How to prevent accidental data loss from executing a query in SQL Server aka “Practicing safe coding”](https://solutioncenter.apexsql.com/wp-content/uploads/2017/08/word-image-10a.png)
How to prevent accidental data loss from executing a query in SQL Server aka “Practicing safe coding”
![How to prevent accidental data loss from executing a query in SQL Server aka “Practicing safe coding” How to prevent accidental data loss from executing a query in SQL Server aka “Practicing safe coding”](https://solutioncenter.apexsql.com/wp-content/uploads/2017/08/word-image-29a.png)