# Microsoft SQL Server and Transaction

**URL:** <https://forum.servoy.com/t/microsoft-sql-server-and-transaction/19395>\
**Category:** Classic Servoy\
**Created:** [August 28, 2017, 8:16pm UTC](https://forum.servoy.com/t/microsoft-sql-server-and-transaction/19395 "2017-08-28T20:16:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![marco.rossi](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@marco.rossi](https://forum.servoy.com/u/marco.rossi)\
**Post date:** [August 28, 2017, 8:16pm UTC](https://forum.servoy.com/t/microsoft-sql-server-and-transaction/19395/1 "2017-08-28T20:16:12Z")

</div>

Hi all,

some years ago, there was danger in using the command databaseManager.startTransaction() on a SQLServer database:  
if one person killed a servoy session while a transaction was open, the entire servoy server freeze and no one could work.

Can anyone tell me if this kind of issue is already fixed?

Best regards and thank you for your time.

Marco

---

<div class="post-metadata">

**Author:** ![murmi](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/murmi/32/4446_2.png) [@murmi](https://forum.servoy.com/u/murmi)\
**Post date:** [August 30, 2017, 6:54am UTC](https://forum.servoy.com/t/microsoft-sql-server-and-transaction/19395/2 "2017-08-30T06:54:39Z")

</div>

Hi Marco  
We had similar Problems with Transactions on a 2008/R2 Server. We issued  
ALTER DATABASE DBName SET READ\_COMMITTED\_SNAPSHOT ON  
ALTER DATABASE DBName SET ALLOW\_SNAPSHOT\_ISOLATION ON  
on each Database and got rid of the problem. Everything works smooth since then.  
Maybe it helps on your problem as well.

Fritz

---

<div class="post-metadata">

**Author:** ![marco.rossi](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@marco.rossi](https://forum.servoy.com/u/marco.rossi)\
**Post date:** [August 30, 2017, 9:41am UTC](https://forum.servoy.com/t/microsoft-sql-server-and-transaction/19395/3 "2017-08-30T09:41:34Z")

</div>

Hi Fritz,

we will try to adopt your solution.  
Thanks for your answer and for your time.

Best regards

Marco Rossi