topic Transaction Isolation: Alfresco 2.1 MS SQL Server 2005 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/transaction-isolation-alfresco-2-1-ms-sql-server-2005/m-p/241818#M194948 <HTML><HEAD></HEAD><BODY><SPAN>I noticed that with Alfresco 3.1 i can configure the support for Transaction Isolation on MS SQL Server, with the parameter:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>db.txn.isolation=4096<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>It's possible to use Transaction Isolation on Alfresco 2.1? I'm not MS SQL Server savy, just need to improve the stability for the next couple of weeks until the new server arrive and i can migrate to Alfresco 3.4 with MySQL on Linux.</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Tue, 26 Oct 2010 18:42:24 GMT pbruna 2010-10-26T18:42:24Z Transaction Isolation: Alfresco 2.1 MS SQL Server 2005 https://connect.hyland.com/t5/alfresco-archive/transaction-isolation-alfresco-2-1-ms-sql-server-2005/m-p/241818#M194948 I noticed that with Alfresco 3.1 i can configure the support for Transaction Isolation on MS SQL Server, with the parameter:db.txn.isolation=4096‍It's possible to use Transaction Isolation on Alfresco 2.1? I'm not MS SQL Server savy, just need to improve the stability for the next couple of weeks un Tue, 26 Oct 2010 18:42:24 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-isolation-alfresco-2-1-ms-sql-server-2005/m-p/241818#M194948 pbruna 2010-10-26T18:42:24Z Re: Transaction Isolation: Alfresco 2.1 MS SQL Server 2005 https://connect.hyland.com/t5/alfresco-archive/transaction-isolation-alfresco-2-1-ms-sql-server-2005/m-p/241819#M194949 <HTML><HEAD></HEAD><BODY><SPAN>In general you can't fiddle with the isolation levels,&nbsp;&nbsp; the default values will have been set for a good reason. </SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>While there may be odd use-cases, such is if you have a read only repo, or a write only repo, don't touch unless you are an </SPAN><BR /><SPAN>expert user, and you are doing something strange.</SPAN></BODY></HTML> Fri, 29 Oct 2010 16:09:54 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-isolation-alfresco-2-1-ms-sql-server-2005/m-p/241819#M194949 mrogers 2010-10-29T16:09:54Z