October 2013 Cumulative Update for SQL Server 2008 R2
Microsoft has released Cumulative Update #9 for SQL Server 2008 R2 Service Pack 2.
- KB Article: KB #2887606
- 17 fixes listed at time of publication
- Build number is 10.50.4295
- Relevant for @@VERSION 10.50.4000 through 10.50.4294
My usual disclaimer: these updates are NOT for SQL Server 2008 (or SQL Server 2012). Only apply to systems where SELECT @@VERSION returns 10.50.xxxx, where xxxx is >= 4000. If xxxx < 4000, you need to start thinking about getting off the RTM or SP1 branch. Note that no more cumulative updates will be released for SP1, since support ended on October 8, 2013.
After applying the CU, Ran 2008R2 BPA and got the following error:
Category: Operation
Source: edited…
Issue: This instance of SQL Server is either missing a fix for a tempdb problem or the required trace flag is not enabled
[ TF 4135 and 4199 not enabled. ]
Impact: The current SQL Server build can result in high severity errors reported for the tempdb database while working with temporary tables
Resolution: Enable Trace Flag 4135 or 4199
I thought this was fixed several CU's ago?
Checked CSS – http://blogs.msdn.com/b/psssql/archive/2010/08/24/why-use-sql-server-2008-r2-bpa-case-1-missing-updates.aspx