Secondary Access to File Stream(s) File, In Open Transaction, May Hanghttp://blogs.msdn.com/b/psssql/archive/2011/05/04/secondary-access-to-file-stream-s-file-in-open-transaction-may-hang.aspxThis post is directly from an issue I have been working on.&#160; The behavior is very difficult to simulate because of the flags and timings involved.&#160;&#160; In this post I will attempt to describe the scenario and provide you with a simple workarounden-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)re: Secondary Access to File Stream(s) File, In Open Transaction, May Hanghttp://blogs.msdn.com/b/psssql/archive/2011/05/04/secondary-access-to-file-stream-s-file-in-open-transaction-may-hang.aspx#10170453Wed, 01 Jun 2011 20:17:34 GMT91d46819-8472-40ad-a661-2c78acb4018c:10170453RDORR<p>We released a SQL Server 2008 R2 Fix for this issue today: &nbsp;<a rel="nofollow" target="_new" href="http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2550552">support.microsoft.com/.../KBHotfix.aspx</a> </p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10170453" width="1" height="1">re: Secondary Access to File Stream(s) File, In Open Transaction, May Hanghttp://blogs.msdn.com/b/psssql/archive/2011/05/04/secondary-access-to-file-stream-s-file-in-open-transaction-may-hang.aspx#10163889Thu, 12 May 2011 17:04:41 GMT91d46819-8472-40ad-a661-2c78acb4018c:10163889psssql<p>RDORR - May 12 2011 Update</p> <p>The FileOption.WriteThrough is helpful but further testing shows it is not a complete workaround. &nbsp;It is helpful but you can still encounter the problem. &nbsp;A fix to the RsFx driver is required to avoid the problem.</p> <p>We are in the process of creating a fix for the RsFx driver.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10163889" width="1" height="1">re: Secondary Access to File Stream(s) File, In Open Transaction, May Hanghttp://blogs.msdn.com/b/psssql/archive/2011/05/04/secondary-access-to-file-stream-s-file-in-open-transaction-may-hang.aspx#10163558Wed, 11 May 2011 21:55:55 GMT91d46819-8472-40ad-a661-2c78acb4018c:10163558Shishir Khandekar<p>Bob, Does FileOptions.WriteThrough guarantee that the server will not hang?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10163558" width="1" height="1">