May 2011 - Technical Rollup Mail - SQL Server
News
Participate in the SQL Server Twitter Challenge !
SQL Server 2008 R2 SP1 CTP Now Available for Testing
Microsoft Windows 7, Windows Server 2008 R2 and SQL Server 2008 SP2 Now Certified as Common Criteria Validated Products
Other
https://blogs.technet.com/trm/default.aspx
Events/Webcasts
PASS DW/BI VC Presents: Creating Dynamic Calculations Using DAX Formulas in PowerPivot
https://www.livemeeting.com/cc/usergroups/join?id=SZSB5Q&role=attend&pw=BdD%5B_7.%2CG
Documents
Essential Guide to SQL Server 2008 R2 for the DBA (Free e-book)
New KB Articles
SQL 2005
Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
FIX: SQL Server Browser service periodically does not respond to incoming requests
https://support.microsoft.com/kb/2526552
Microsoft SQL Server 2005 Standard Edition
The target server cannot download a multiserver job from the master server if the target server is running a German version or a French version of SQL Server 2005 or a German version of SQL Server 2008 R2
https://support.microsoft.com/kb/949775
SQL 2008
Microsoft SQL Server 2008 Developer
FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used
https://support.microsoft.com/kb/2520808
Microsoft SQL Server 2008 Enterprise
FIX: DML statements do not run on some columns in a table after you enable CDC on some other columns in SQL Server 2008 R2
https://support.microsoft.com/kb/2532079
SQL 2008 R2
Microsoft SQL Server 2008 R2 Analysis Services
FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 R2 Analysis Services
https://support.microsoft.com/kb/2531172
Microsoft SQL Server 2008 R2 Analysis Services
FIX: MDX query incorrectly returns NULL or 0 values for some measures if a calculated member is used on the row axis in SSAS 2008 R2
https://support.microsoft.com/kb/2518876
Microsoft SQL Server 2008 R2 Analysis Services
FIX: "CPerIndexMetaQS::ErrorAbort - Index corruption" error when you try to update a partitioned view in SQL Server 2008 R2
https://support.microsoft.com/kb/2451688
Microsoft SQL Server 2008 R2 Analysis Services
How to obtain the latest service pack for SQL Server 2008 R2
https://support.microsoft.com/kb/2527041
Microsoft SQL Server 2008 R2 Datacenter
Cumulative Update package 7 for SQL Server 2008 R2
https://support.microsoft.com/kb/2507770
Microsoft SQL Server 2008 R2 Datacenter
FIX: "Expression: (pCopySrc - command) <= (int) cmdLength" error when you add a column to a table published in a transactional publication in SQL Server 2008 R2
https://support.microsoft.com/kb/2518808
Microsoft SQL Server 2008 R2 Datacenter
FIX: "The script '/MDM/ScriptResource.axd' contains multiple calls to Sys.Application.notifyScriptLoaded(). Only one is allowed" error on a SQL Server 2008 R2 MDS website
https://support.microsoft.com/kb/2516439
Microsoft SQL Server 2008 R2 Datacenter
FIX: Assertion error when you try to recover a database in SQL Server 2008 R2
https://support.microsoft.com/kb/2503834
Microsoft SQL Server 2008 R2 Datacenter
FIX: "Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION" and SQL Server 2008 R2 crashes when you start a SQL Server Extended event session and perform actions that are bound to events in the Xevent session on a case-sensitive database
https://support.microsoft.com/kb/2515489
Microsoft SQL Server 2008 R2 Datacenter
FIX: A database that has transparent data encryption enabled may be marked as "suspect" if the server certificate is dropped in SQL Server 2008 R2
https://support.microsoft.com/kb/2463682
Microsoft SQL Server 2008 R2 Datacenter
You receive an error message when you try to browse directly to the SSRS 2008 R2 report server after you create a SharePoint claim site
https://support.microsoft.com/kb/981588
Microsoft SQL Server 2008 R2 Enterprise
FIX: The IntelliSense feature in SQL Server Management Studio for SQL Server 2008 R2 may stop working after you install Visual Studio 2010 Service Pack 1
https://support.microsoft.com/kb/2531482
Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010
FIX: PowerPivot window does not open when you open an .xla or .xlam file in Excel 2010 if PowerPivot for Excel 2010 is installed
https://support.microsoft.com/kb/2521127
Microsoft SQL Server 2008 R2 Reporting Services
FIX: Performance decreases after you move a report that contains a large multi-select drop-down parameter list to SQL Server 2008 R2 Reporting Services
https://support.microsoft.com/kb/2522708
Microsoft SQL Server 2008 R2 Reporting Services
FIX: Permission error when you view a folder by using the "ViewMode=WebpartList" parameter in the query string for Report Manager in SQL Server 2008 R2 Reporting Services
https://support.microsoft.com/kb/2520240
Microsoft SQL Server 2008 R2 Reporting Services
FIX: Report builder 3.0 stops responding after you run a query more than two times against a report model in SSRS 2008 R2
https://support.microsoft.com/kb/2516163
Microsoft SQL Server 2008 R2 Reporting Services
FIX: Performance decreases after you move a large report to SQL Server 2008 R2 Reporting Services
https://support.microsoft.com/kb/2506799
Microsoft SQL Server 2008 R2 Reporting Services
FIX: A report displays incorrect results if you use a filtered shared dataset in a SQL Server 2008 R2 report
https://support.microsoft.com/kb/2515006
Microsoft SQL Server 2008 R2 Reporting Services
FIX: A hidden text box value that is referenced in the Tablix header is displayed only on the first page when you export a report to any hard page-break rendering format in SQL Server 2008 R2 Reporting Services
https://support.microsoft.com/kb/2494517
Microsoft SQL Server 2008 R2 Standard
List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 1 CTP