{"id":3483,"date":"2012-05-14T11:45:00","date_gmt":"2012-05-14T18:45:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/"},"modified":"2024-01-22T22:49:42","modified_gmt":"2024-01-23T06:49:42","slug":"sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/","title":{"rendered":"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available"},"content":{"rendered":"<p><span style=\"font-family:'Segoe UI';font-size:small;\">As part of our commitment to delivering and supporting high-quality software to our customers, Microsoft is pleased to announce SQL Server 2008 R2 SP2 CTP. Customers with existing investments on SQL Server 2008 R2 are encouraged to explore Service Pack 2 CTP. Service Pack 2 for SQL Server 2008 R2 includes product improvements based on requests from the SQL Server community and hotfix solutions provided in SQL Server 2008 R2 SP1 Cumulative Updates 1 to 5. A few highlights are as follows:<\/span><\/p>\n<ul>\n<li><span style=\"font-family:'Segoe UI';\"><span style=\"font-size:small;\"><b>Reporting Services Charts Maybe Zoomed &amp; Cropped <br \/><\/b>Customers using Reporting Services on Windows 7 may sometime find charts are zoomed in and cropped.\u00a0 To work around the issue some customers set ImageConsolidation to false.\u00a0\u00a0\u00a0 <\/span><\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-family:'Segoe UI';\"><span style=\"font-size:small;\"><b>Batch Containing Alter Table not Cached <br \/><\/b>In certain situations with batch files containing the alter table command, the entire batch file is not cached.\u00a0\u00a0\u00a0 <\/span><\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-family:'Segoe UI';\"><span style=\"font-size:small;\"><b>Collapsing Cells or Rows, If Hidden Render Incorrectly <br \/><\/b>Some customers who have hidden rows in their Reporting Services reports may have noticed rendering issues when cells or rows are collapsed.\u00a0 When writing a hidden row, the Style attribute is opened to write a height attribute. If the attribute is empty and the width should not be zero.\u00a0\u00a0\u00a0 <\/span><\/span><\/li>\n<\/ul>\n<ul><\/ul>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">SQL Server 2008 R2 SP2 provides software solutions for these customer reported issues and more.\u00a0 For more details please visit the KB article <\/span><a href=\"http:\/\/support.microsoft.com\/kb\/2630455\"><span style=\"font-family:'Segoe UI';font-size:small;\">2630455<\/span><\/a><span style=\"font-family:'Segoe UI';font-size:small;\"> accompanying the SQL Server 2008 R2 SP2 CTP release. Customers running SQL Server 2008 R2 can now download and test the SP2 CTP and send feedback to Microsoft for continuous product improvement.<\/span><\/p>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">To download the SQL Server 2008 R2 SP2 release please select from the links below:<\/span><\/p>\n<ul>\n<ul>\n<li><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=251790\"><span style=\"font-family:'Segoe UI';font-size:small;\">SQL Server 2008 R2 SP2 CTP<\/span><\/a><\/li>\n<\/ul>\n<\/ul>\n<ul>\n<ul>\n<li><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=251791\"><span style=\"font-family:'Segoe UI';font-size:small;\">SQL Server 2008 R2 SP2 CTP Express<\/span><\/a><\/li>\n<\/ul>\n<\/ul>\n<ul>\n<ul>\n<li><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkId=251792\"><span style=\"font-family:'Segoe UI';font-size:small;\">SQL Server 2008 R2 SP2 CTP Feature Pack<\/span><\/a><\/li>\n<\/ul>\n<\/ul>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">We look forward to your feedback!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As part of our commitment to delivering and supporting high-quality software to our customers, Microsoft is pleased to announce SQL Server 2008 R2 SP2 CTP. Customers with existing investments on SQL Server 2008 R2 are encouraged to explore Service Pack 2 CTP.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-3483","post","type-post","status-publish","format-standard","hentry","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"As part of our commitment to delivering and supporting high-quality software to our customers, Microsoft is pleased to announce SQL Server 2008 R2 SP2 CTP. Customers with existing investments on SQL Server 2008 R2 are encouraged to explore Service Pack 2 CTP.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2012-05-14T18:45:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available\",\"datePublished\":\"2012-05-14T18:45:00+00:00\",\"dateModified\":\"2024-01-23T06:49:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/\"},\"wordCount\":288,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/\",\"name\":\"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-05-14T18:45:00+00:00\",\"dateModified\":\"2024-01-23T06:49:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available - Microsoft SQL Server Blog","og_description":"As part of our commitment to delivering and supporting high-quality software to our customers, Microsoft is pleased to announce SQL Server 2008 R2 SP2 CTP. Customers with existing investments on SQL Server 2008 R2 are encouraged to explore Service Pack 2 CTP.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-05-14T18:45:00+00:00","article_modified_time":"2024-01-23T06:49:42+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available","datePublished":"2012-05-14T18:45:00+00:00","dateModified":"2024-01-23T06:49:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/"},"wordCount":288,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/","name":"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-05-14T18:45:00+00:00","dateModified":"2024-01-23T06:49:42+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/14\/sql-server-2008-r2-service-pack-2-customer-technology-preview-ctp-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=3483"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3483\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=3483"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=3483"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=3483"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=3483"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=3483"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=3483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}