<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlblog.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Search results matching tags 'SP2', 'RTM', 'hotfixes', 'CTP', and 'cumulative updates'</title><link>http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&amp;tag=SP2,RTM,hotfixes,CTP,cumulative+updates&amp;orTags=0</link><description>Search results matching tags 'SP2', 'RTM', 'hotfixes', 'CTP', and 'cumulative updates'</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>SQL Server 2008 R2 Service Pack 2 CTP is available</title><link>http://sqlblog.com/blogs/aaron_bertrand/archive/2012/05/14/sql-server-2008-r2-service-pack-2-ctp-is-available.aspx</link><pubDate>Mon, 14 May 2012 18:23:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:43345</guid><dc:creator>AaronBertrand</dc:creator><description>You can download the Service Pack 2 CTP from the following URL: &lt;br&gt;

&lt;blockquote&gt;&lt;p&gt;&lt;a href="http://www.microsoft.com/en-us/download/details.aspx?id=29848" target="_blank"&gt;http://www.microsoft.com/en-us/download/details.aspx?id=29848&lt;/a&gt;&lt;/p&gt;&lt;/blockquote&gt;


&lt;p&gt;The build # is 10.50.3720. This service pack contains all of the fixes from Service Pack 1 &amp;amp; Cumulative Updates 1 through 5, and a couple of other minor fixes (a couple of SSRS bugs and a bug about an ALTER TABLE batch not being cached correctly). It does not include fixes from Service Pack 1 Cumulative Update #6, which &lt;a href="http://sqlblog.com/blogs/aaron_bertrand/archive/2012/04/17/new-cumulative-updates-for-sql-server-2008-r2-rtm-sp1-are-available.aspx" title="http://sqlblog.com/blogs/aaron_bertrand/archive/2012/04/17/new-cumulative-updates-for-sql-server-2008-r2-rtm-sp1-are-available.aspx" target="_blank"&gt;I mentioned recently&lt;/a&gt;.&lt;/p&gt;&lt;p&gt;You should &lt;b&gt;*NOT*&lt;/b&gt; install this service pack preview if:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt; your build number (SELECT @@VERSION;) is 10.00.xxxx (since this is SQL Server 2008, not SQL Server 2008 R2);&lt;br&gt;&lt;/li&gt;

&lt;li&gt;your build number is &amp;gt;= 10.50.1815 and &amp;lt; 10.50.2500 (since you may be undoing fixes you are using from RTM CU13); or,&lt;br&gt;&lt;/li&gt;

&lt;li&gt;your build number is &amp;gt;= 10.50.2811 (since you will be undoing fixes you might be using from SP1 CU6).&lt;br&gt;&amp;nbsp;&lt;br&gt;&lt;/li&gt;
&lt;/ul&gt;</description></item></channel></rss>