News

Microsoft SQL Server 2008

SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights.

http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx

http://download.microsoft.com/download/B/F/2/BF24C54E-5635-4C79-AFB4-0C3F840E79F4/SQLServer2008_Datasheet_Final.pdf

Using SQL Server Table-Valued User-defined Functions with Exchange Web Services

The SQL Server Tables and Exchange Web Services sample takes advantage of two powerful new features in SQL Server and Microsoft Exchange: table-valued user-defined functions, and Exchange Web Services. Table-valued user-defined functions in SQL Server return a table, much like a SQL Server view, but provide for much more powerful logic. Exchange Web Services in Exchange 2007 provides access to Exchange store items and information, such as message, contact, task, and calendar items and availability information.  When you combine these technologies, you have a formidable new way to integrate, search, and analyze your Microsoft Exchange messaging data by using the full power of SQL Server, and to combine that messaging data with virtually any other data managed by, or available from, SQL Server.

http://msdn2.microsoft.com/en-us/sql/bb483139.aspx

Microsoft Details Dynamic IT Strategy at Tech•Ed 2007

Bob Muglia, senior vice president of the Server and Tools Business at Microsoft Corp., today kicked off the 15th annual Microsoft® Tech•Ed conference by detailing the company’s strategy for Dynamic IT for the People-Ready Business (Dynamic IT). Dynamic IT builds on the company’s Dynamic Systems Initiative and ongoing Application Platform efforts to provide customers with the key areas of technical innovation necessary to make their IT and development organizations more strategic to the business.

http://www.microsoft.com/presspass/press/2007/jun07/06-04TechED07PR.mspx

http://www.microsoft.com/presspass/press/2007/jun07/06-04DynamicITVideos.mspx

SQL Server Premier Field Engineers Deliver SoundBytes

The UK SQL Server PFE team is preparing a series of SQL Server SoundBytes aimed to deliver proactive content to our Premier customers via LiveMeeting. Premier SoundByte sessions will be ideal for customers who need proactive information, for whom it may not be convenient to leave the office to come to a workshop. These sessions are set to run from the beginning of September 2007 through to the end of December 2007 and will range from Clustering a SQL Server 2005 Database System, to Database Mirroring, Configuration Best Practices through to SQL Server in a SAN Environment, Corruption / Detection and Recovery of a SQL Server 2005 System.  Please contact your TAM if you are interested in attending a SoundByte Session and they will arrange your attendance for the specific topic, agenda and date / time.  For more information regarding these SQL Server 2005 SoundBytes, checkout the UK SQL Server Premier Blogsite :

http://sqlblogcasts.com/blogs/thepremiers/

Documents

SQL Server 2008 Product Overview

For organizations to be successful and thrive in today’s world of data, they need a vision that addresses key data trends. The data platform vision of Microsoft helps organizations meet these data explosion needs and the next generation of data-driven applications. Microsoft will continue to invest in and evolve the following key areas to support their data platform vision: mission-critical enterprise data platform, dynamic development, relational data, and business intelligence. Read this paper to learn about the Microsoft Data Platform Vision and how SQL Server 2008 meets the needs of the next generation of data-driven applications.

http://www.microsoft.com/sql/techinfo/whitepapers/sql2008Overview.mspx

Reporting Services: Using XML and Web Service Data Sources

New to Microsoft SQL Server 2005 Reporting Services (SSRS) is integrating Report Services directly with XML data sources and Web services. This white paper provides general information and tips for designing reports using these sources. It is intended to provide a starting point and overview of the available features, in addition to outlining many common scenarios. The intended audience is more experienced report authors who want to extend and integrate reporting with more services-oriented environments.

http://msdn2.microsoft.com/en-us/library/aa964129.aspx

Downloads

Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005

The Microsoft SQL Server Management Pack provides both proactive and reactive monitoring of SQL Server 2005 and SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, performance data collection, and default thresholds are built for enterprise-level monitoring. Both local and remote connectivity checks help ensure database availability. With the embedded expertise in the SQL Server Management Pack, you can proactively manage SQL Server, and identify issues before they become critical. This Management Pack increases the security, availability, and performance of your SQL Server infrastructure.

http://www.microsoft.com/downloads/details.aspx?FamilyID=79f151c7-4d98-4c2b-bf72-ec2b4ae69191&DisplayLang=en

Credit Suisse Develops and Deploys SOX 404 Compliance Solution using SQL Server 2005

Credit Suisse, based in Zurich, Switzerland, provides investment banking, private banking, and asset management services to clients in more than 50 countries. Because its shares are traded on the New York Stock Exchange, the company had to comply with regulations specifying internal controls introduced by the U.S. Securities and Exchange Commission (SEC) Sarbanes-Oxley Act of 2002 (SOX) Section 404. With more than 45,000 employees working around the world, Credit Suisse needed a SOX 404 compliance solution that was scalable and that could integrate with its line of business operations. Credit Suisse developed a SOX 404 compliance application based on Microsoft® SQL Server™ 2005 database and accessed across the Web through a portal supported by Microsoft Office SharePoint® Services. The solution was developed using Microsoft Visual Studio® 2005 and the Microsoft .NET Framework.

http://www.microsoft.com/downloads/details.aspx?FamilyID=b0d4a6fe-c644-4bbb-b421-d920c280368c&DisplayLang=en

SQL Server 2005 Books Online (May 2007)

Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The May 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to "New and Updated Books Online Topics" for a list of topics that are new or updated in this version. Topics with significant updates have a Change History table at the bottom of the topic that summarizes the changes. Beginning with the February 2007 update, SQL Server 2005 Books Online reflects product upgrades included in SQL Server 2005 Service Pack 2 (SP2).

http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en

Singaporean Insurance Provider Gains 300 per cent Performance Improvement

NTUC Income uses Microsoft SQL ServerTM 2005, and Microsoft SQL Server 2005 Reporting Services to mine customer data and quickly deliver reports. This will help its decision makers to accurately target the right customers with appropriate insurance services.ge technical white paper details how the Microsoft IT group manages server security patching.

http://www.microsoft.com/downloads/details.aspx?FamilyID=c79a9a91-bc72-474d-ba16-1af6e3eca297&DisplayLang=en

Premier Asian Film Company, Shaw, Boosts Customer Service using SQL Server 2005 and Visual Studio 2005

As part of its service, Shaw Organisation provides an automated ticketing service for cinemagoers. Customers purchase tickets and select seats via a number of channels including the Internet, telephone and the cinema box office. Shaw Organisation wanted to consolidate these channels and improvie customer service. See how Shaw benefited from Microsoft® Visual Studio® 2005, the Microsoft .NET Framework 2.0, and Microsoft SQL ServerTM 2005

http://www.microsoft.com/downloads/details.aspx?FamilyID=540d8d7c-27a8-4a12-8db0-c1a7a19fa547&DisplayLang=en

.NET Rocks! - Bret Updegraff Talks SQL Server Reporting Services

An experienced software designer and developer, Bret Updegraff works as a manager with the Mid Market Microsoft practice of Crowe Chizek and Company LLC. Bret was honored with the Microsoft MVP status from Microsoft in the category of Windows Server System - SQL Server. He is a Microsoft Certified Solution Developer, a Microsoft Certified Application Developer, and a Microsoft Certified Database Administrator. Bret is the president of the Indianapolis Professional Association of SQL Server (PASS) users group as well as the co-author of the book Reporting Services 2005 In Action by Manning Publishing.

http://www.microsoft.com/downloads/details.aspx?FamilyID=153e2378-0313-4718-a99a-1334a6803f6d&DisplayLang=en

Podcasts: How Microsoft Uses SQL Server 2005 to Power a Global Forensic Data Security Tool

The Information Security team at Microsoft uses an internal tool called Information Security Consolidated Event Management (ICE 3.0) to gather forensic data from more than 85 proxy servers around the world. Powered by SQL Server 2005, the 27 TB data management system collects different types of global evidence, such as inbound and outbound e-mail traffic, Login events, and Web browsing, into a single database. ICE 3.0 provides rapid security analysis and queries, robust proxy performance analysis, and extensive troubleshooting functionality. Table level partitions allow event processing and database loading, without affecting the ongoing query activities and analysis work of security forensics engineers. Storage Area Networking (SANs) manage enterprise storage for ICE 3.0, and the service maintains an uptime of 99.9%. A controller application dynamically launches multiple instances of SQL Server Integration Services (SSIS), which seamlessly respond to changes in the volume of incoming evidence. The tool was redesigned in 2006 using SQL Server 2005. The SQL upgrade enhanced the data feed process, query response time, expanded the data retention period, and reduced manual data loading and data validations.

http://www.microsoft.com/downloads/details.aspx?FamilyID=e3e6f083-a8b7-44cc-9893-16ae6dd6d8a1&DisplayLang=en

Microsoft Visual FoxPro 9.0 Service Pack 2 and "Sedna" - Beta

This download contains the BETA release for Microsoft Visual FoxPro 9.0 SP2 and the "Sedna" add-ons. This release has two parts:

The Sedna Beta download contains six components: VistaDialogs4COM, Upsizing Wizard, Data Explorer, NET4COM, MY for VFP and VS 2005 Extension for VFP.
The VFP 9.0 SP2 Beta download contains a patch that can be applied to VFP 9.0 or VFP 9.0 SP1. In addition to fixes to the core product, this patch contains significant enhancements to the Reporting features. Note that the SP2 patch can only be applied to VFP 9.0 or VFP 9.0 SP1.

http://www.microsoft.com/downloads/details.aspx?FamilyID=05A0E7C9-43C1-417F-8810-AE7D7C66BAC8&displaylang=en

Events/WebCasts

SQL 2005 Webcasts and Virtual Labs

SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage.  Choose from a wide range of live and on-demand webcasts.  Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities.

SQL Server 2005 Webcasts

MSDN Webcast: ADO.NET Step by Step (Part 09 of 16): Using DataViews (Level 200)   Thursday, July 05, 2007 9:00 AM Pacific Time (US & Canada)

This webcast series is based on Microsoft ADO.NET Step by Step, by Rebecca M. Riordan (Microsoft Press, 2002). In this installment, we examine how the DataView can help you filter and sort DataRows at design time. We discuss how you can add a DataView to a form and use it to examine and view data in an application. Get a solid handle on ADO.NET and discover how to take advantage of the database functionality of Microsoft Visual Basic .NET and Microsoft Visual C# .NET with this step-by-step primer. Attend this session to start working with ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Find out how you can use the ADO.NET object model to develop data-bound Windows Forms and Web Forms. We explain how ADO.NET interacts with XML and describe how to access older versions of ActiveX Data Objects (ADO) from the .NET Framework environment. Throughout, we provide insightful tips and expert explanations of how ADO.NET can help you accelerate development productivity, build faster applications, and deliver more powerful results.

MSDN Webcast: ADO.NET Step by Step (Part 09 of 16): Using DataViews (Level 200)

Microsoft West Region VAR Community Call Monday, July 09, 2007 1:00 PM Pacific Time (US & Canada)

Monthly update for resellers who sell Open and Open Value in SMB July 2007 Edition

This monthly call covers hot training opportunities, upcoming marketing programs, sales incentives, tools, resources and promotions!  The goal of this monthly call is to help you stay current on Microsoft resources that help facilitate more sales for you and your organization!

Microsoft West Region VAR Community Call

MSDN Webcast: ADO.NET Step by Step (Part 10 of 16): Editing and Updating Data (Level 200) Wednesday, July 11, 2007 9:00 AM Pacific Time (US & Canada)

This webcast series is based on Microsoft ADO.NET Step by Step, by Rebecca M. Riordan (Microsoft Press, 2002). In this session, we explore how ADO.NET objects work together to perform specific tasks. We concentrate on editing and updating data using the objects we discussed in previous sessions, including DataViews, TableAdapters, DataTables, and DataSets. Get a solid handle on ADO.NET and discover how to take advantage of the database functionality of Microsoft Visual Basic .NET and Microsoft Visual C# .NET with this step-by-step primer. Attend this session to start working with ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Find out how you can use the ADO.NET object model to develop data-bound Windows Forms and Web Forms. We explain how ADO.NET interacts with XML and describe how to access older versions of ActiveX Data Objects (ADO) from the .NET Framework environment. Throughout, we provide insightful tips and expert explanations of how ADO.NET can help you accelerate development productivity, build faster applications, and deliver more powerful results.

MSDN Webcast: ADO.NET Step by Step (Part 10 of 16): Editing and Updating Data (Level 200)

MSDN Webcast: ADO.NET Step by Step (Part 11 of 16): Data-Binding in Windows Forms with the BindingSource Class (Level 200) Wednesday, July 18, 2007 9:00 AM Pacific Time (US & Canada)

This webcast series is based on Microsoft ADO.NET Step by Step, by Rebecca M. Riordan (Microsoft Press, 2002). In this session, we discuss how you can bind data to your Windows Forms. First, we examine the underlying mechanisms that bind controls to ADO.NET data sources. Next, we take a look at the BindingSource class, new in ADO.NET version 2.0, which acts as an intermediary between a data source and Windows Forms controls to simplify and extend the data-binding process. Get a solid handle on ADO.NET and discover how to take advantage of the database functionality of Microsoft Visual Basic .NET and Microsoft Visual C# .NET with this step-by-step primer. Attend this session to start working with ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Find out how you can use the ADO.NET object model to develop data-bound Windows Forms and Web Forms. We explain how ADO.NET interacts with XML and describe how to access older versions of ActiveX Data Objects (ADO) from the .NET Framework environment. Throughout, we provide insightful tips and expert explanations of how ADO.NET can help you accelerate development productivity, build faster applications, and deliver more powerful results.

MSDN Webcast: ADO.NET Step by Step (Part 11 of 16): Data-Binding in Windows Forms with the BindingSource Class (Level 200)

TechNet Webcast: An Overview of Manageability in Microsoft SQL Server 2008 (Level 200) Tuesday, July 24, 2007 11:30 AM Pacific Time (US & Canada)

In this webcast, we focus on the database engine in Microsoft SQL Server 2008 to teach you more about what is in store for policy-driven administration and performance data collection and analysis. For your organization to thrive in today's world of data, you need a vision to address your data explosion needs. Join this session to see the exciting new manageability features in Microsoft SQL Server 2008 that target these needs while reducing total cost of ownership (TCO).

TechNet Webcast: An Overview of Manageability in Microsoft SQL Server 2008 (Level 200)

MSDN Webcast: ADO.NET Step by Step (Part 12 of 16): Using ADO.NET in Windows Forms (Level 200) Wednesday, July 25, 2007 9:00 AM Pacific Time (US & Canada)

This webcast series is based on Microsoft ADO.NET Step by Step, by Rebecca M. Riordan (Microsoft Press, 2002). In this session, we expand on our discussion from the previous webcast on binding data sources to Windows Forms. We explore using this new functionality to perform some common tasks like formatting data, displaying related data, and working with events. Get a solid handle on ADO.NET and discover how to take advantage of the database functionality of Microsoft Visual Basic .NET and Microsoft Visual C# .NET with this step-by-step primer. Attend this session to start working with ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Find out how you can use the ADO.NET object model to develop data-bound Windows Forms and Web Forms. We explain how ADO.NET interacts with XML and describe how to access older versions of ActiveX Data Objects (ADO) from the .NET Framework environment. Throughout, we provide insightful tips and expert explanations of how ADO.NET can help you accelerate development productivity, build faster applications, and deliver more powerful results.

MSDN Webcast: ADO.NET Step by Step (Part 12 of 16): Using ADO.NET in Windows Forms (Level 200)

MSDN Webcast: MSDN geekSpeak: Real World SQL Server Integration Services Stories with Matthew Roche (Level 200) Wednesday, July 25, 2007 12:00 PM Pacific Time (US & Canada)

MSDN geekSpeak is a new kind of webcast series, hosted by Glen Gordon and Lynn Langit from the MSDN Events team. Dispensing with slide decks and scripted demos, geekSpeak webcasts bring you industry experts in a "talk-radio" format. These experts share their knowledge of and experience with a particular developer technology. Hear about industry trends, new technology, real-world experiences, and more. During the webcast, you can have your questions answered in real time, hear a lively discussion and debate, and add your comments to the fray. Who knows, you might even see a whiteboard sketch or an off-the-cuff demo. This is another way for you, the developer, to engage with Microsoft in an interesting and effective way! In this installment of geekSpeak, Matthew Roche shares some real-world stories of using Microsoft SQL Server Integration Services (SSIS).

MSDN Webcast: MSDN geekSpeak: Real World SQL Server Integration Services Stories with Matthew Roche (Level 200)

TechNet Webcast: Data Warehousing Enhancements in Microsoft SQL Server 2008 (Level 200) Thursday, July 26, 2007 11:30 AM Pacific Time (US & Canada)

Join this webcast to learn about the enhancements for data warehousing in the next version of Microsoft SQL Server. We discuss how Microsoft SQL Server 2008 provides a comprehensive, scalable data warehouse platform that enables you to quickly build a data warehouse. By integrating all relevant data into a comprehensive warehouse platform, SQL Server 2008 empowers you to manage your growing data volumes with an enterprise-ready relational database and deliver actionable insights with the integration of the Microsoft Business Intelligence (BI) platform.

TechNet Webcast: Data Warehousing Enhancements in Microsoft SQL Server 2008 (Level 200)

TechNet Webcast: Going Beyond Relational Data with Microsoft SQL Server 2008 (Level 200) Monday, July 30, 2007 1:00 PM Pacific Time (US & Canada)

As the data your applications work with changes from "words and numbers" to "sights and sounds," we are evolving our data platform to go beyond relational data, beyond online analytical processing (OLAP), to truly support all of the digital data types of the future. We strive to deliver the best platform for integrated storage and advanced applications, such as spatial data. We also make it dramatically easier for you to build data-driven applications, without needing to invest significant resources to bridge the gap between data and programming language data structures. Join this webcast to learn about the new enhancements in Microsoft SQL Server 2008 that can help you manage all types of data.

TechNet Webcast: Going Beyond Relational Data with Microsoft SQL Server 2008 (Level 200)

Further on-demand webcasts are available here: http://www.microsoft.com/events/series/technetsqlserver2005.mspx

New KB’s

SQL Server 2000 Standard Edition

You receive an error message when you try to attach a SQL Server 2005 database in SQL Server 2000

http://support.microsoft.com/?kbid=937758

FIX: Incorrect data is inserted unexpectedly when you perform a bulk copy operation by using the DB-Library API in SQL Server 2000 Service Pack 4

http://support.microsoft.com/?kbid=904244

FIX: The foreign key that you created between two tables does not work after you run the CREATE INDEX statement in SQL Server 2000

http://support.microsoft.com/?kbid=935950

An updated version of Sqlvdi.dll is now available for SQL Server 2000

http://support.microsoft.com/?kbid=935465

FIX: A deadlock occurs when the scheduled SQL Server Agent job that you add or that you update is running in SQL Server 2000

http://support.microsoft.com/?kbid=915340

SQL Server 2005 Standard Edition

The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005

http://support.microsoft.com/?kbid=937531

Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the Backup tool: "Restore failed for Server '<ServerName>' (Microsoft.SqlServer.Smo)"

http://support.microsoft.com/?kbid=937683

Error message when you run the ALTER SCHEMA statement in SQL Server 2005: “The object with name '<ObjectName>' already exists”

http://support.microsoft.com/?kbid=937757

FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections

http://support.microsoft.com/?kbid=937745

FIX: The getTime method returns an incorrect date in the SQL Server 2005 JDBC Driver 1.1

http://support.microsoft.com/?kbid=936697

Error message when you register an assembly in SQL Server 2005: "CREATE ASSEMBLY for assembly 'Microsoft.SqlServer.Smo' failed because assembly 'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly"

http://support.microsoft.com/?kbid=937685

You may be prompted to restart the computer after you install the 64-bit version of SQL Server 2005 Service Pack 2 even if the Setup program does not report that some components are locked

http://support.microsoft.com/?kbid=937684

FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database

http://support.microsoft.com/?kbid=937544

A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2

http://support.microsoft.com/?kbid=938085

FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk

http://support.microsoft.com/?kbid=935446

Explanation of error 3928 in SQL Server 2005 and in SQL Server 2000

http://support.microsoft.com/?kbid=937950

FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2005, the result is still returned in random order

http://support.microsoft.com/?kbid=926292

You receive an error message after you install SQL Server 2005 Service Pack 2 when you try to edit a Script component that is inside an SSIS package and the SSIS package was created in an earlier version of SQL Server 2005

http://support.microsoft.com/?kbid=938608

FIX: Error message when you use transactional replication to replicate the execution of stored procedures to subscribers in SQL Server 2005: "Insufficient memory to run query"

http://support.microsoft.com/?kbid=933499

FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: “The XML data type is damaged”

http://support.microsoft.com/?kbid=933808

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released

http://support.microsoft.com/?kbid=937137

FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP1: "The OLE DB provider "BULK" for linked server "(null)" reported an error"

http://support.microsoft.com/?kbid=937545

FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1

http://support.microsoft.com/?kbid=932393

Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available

http://support.microsoft.com/?kbid=936305

FIX: Error message when you run a linked server query in SQL Server 2005: "The oledbprovider unisys.dmsII.1 for linkserver '<ServerName>' reported an error the provider ran out of memory"

http://support.microsoft.com/?kbid=937033

FIX: A memory leak occurs when you use the sp_OAMethod stored procedure to call a method of a COM object in SQL Server 2005

http://support.microsoft.com/?kbid=937277

FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005

http://support.microsoft.com/?kbid=933762

FIX: Error messages when you run a query that references a view in SQL Server 2005 Service Pack 2: “A severe error occurred on the current command. The results, if any, should be discarded”

http://support.microsoft.com/?kbid=938102

FIX: The update may take a longer time to complete in SQL Server 2005 than in SQL Server 2000 when you update subscribers of a transactional publication that has immediate updating subscriptions enabled

http://support.microsoft.com/?kbid=938675

FIX: SQL Server 2005 stops and then restarts unexpectedly and errors occur in the tempdb database

http://support.microsoft.com/?kbid=937343

FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: “The merge process failed to execute a query because the query timed out”

http://support.microsoft.com/?kbid=934065

FIX: Hebrew characters are incorrectly converted when you synchronize a replication subscription in SQL Server 2005

http://support.microsoft.com/?kbid=938068

SQL Server 2005 Mobile Edition

FIX: An access violation occurs when you run the SqlCeEngine.Verify method to check for the consistency of a database in SQL Server 2005 Compact Edition or in SQL Server 2005 Mobile Edition

http://support.microsoft.com/?kbid=936978

FIX: Error message when you upgrade a database from SQL Server 2000 Windows CE Edition 2.0 to SQL Server 2005 Mobile Edition: "The database file is larger than the configured maximum database size"

http://support.microsoft.com/?kbid=935769

SQL Server 2005 Analysis Services

FIX: Error message when you run an MDX query against a measure in SQL Server 2005 Analysis Services: "An internal error has occurred"

http://support.microsoft.com/?kbid=935341

Slow performance when you run an MDX query that accesses the key attribute hierarchy in a parent-child dimension in SQL Server 2005 Analysis Services

http://support.microsoft.com/?kbid=938495

FIX: Error message when you run an MDX query that retrieves data from an Analysis Services database: "An error occurred while the dimension, with the ID of '<DatabaseName>', Name of '<DimensionName>' was being processed"

http://support.microsoft.com/?kbid=935360

FIX: Seven connections are created and the connections are not reused when you connect to an instance of SQL Server 2005 Analysis Services

http://support.microsoft.com/?kbid=913367

FIX: The client application stops responding, and the Msmdsrv.exe process uses all the available memory after you perform the filtering operation and the browsing operation against an instance of SQL Server 2005 Analysis Services

http://support.microsoft.com/?kbid=938077

FIX: You cannot drill down a dimension from the (All) level in SQL Server 2005 Analysis Services build 1507

http://support.microsoft.com/?kbid=913552

FIX: The estimate of the number of children that a dimension member has may be inaccurate when you request the CHILDREN_CARDINALITY property for a dimension member in SQL Server 2005 Analysis Services

http://support.microsoft.com/?kbid=936595

FIX: Some values of measures in a cube unexpectedly appear as "#N/A" when you enable the "Enable read-contingent permissions" option for the cube in SQL Server 2005 Analysis Services Service Pack 2

http://support.microsoft.com/?kbid=936080

FIX: Additional data columns for ascendant members are returned unexpectedly when you run an MDX statement against an instance of SQL Server 2005 Analysis Services that has SQL Server 2005 Service Pack 2 installed

http://support.microsoft.com/?kbid=938585

FIX: Error message when you run an MDX query against a database in SQL Server 2005 Service Pack 2: “An unexpected exception occured”

http://support.microsoft.com/?kbid=937829

FIX: You obtain an incorrect prediction when you browse a mining structure that is created by using the Microsoft Association algorithm in SQL Server 2005 Analysis Services

http://support.microsoft.com/?kbid=932608

SQL Server 2005 Reporting Services

FIX: The background color of a report may be black when the report is hosted by a report server in SQL Server 2005 Reporting Services

http://support.microsoft.com/?kbid=935436

FIX: A table in a report that is delivered by SQL Server 2005 Reporting Services with Service Pack 2 appears to be compressed when the report is opened in Outlook 2007

http://support.microsoft.com/?kbid=935399

FIX: Rows in a table are not aligned correctly in a SQL Server 2005 Reporting Services report when you view the deployed report in a browser

http://support.microsoft.com/?kbid=937149

FIX: Error messages are logged, and some threads may not sort the data successfully if many threads are displaying a report in SQL Server 2005 Reporting Services

http://support.microsoft.com/?kbid=936253