News

Now Available – SQL Server 2005 Service Pack 2 With New Features, Increased Performance

Microsoft SQL Server 2005 Service Pack 2 (SP2) enables all editions of SQL Server 2005 to take advantage of the enhancements within Windows Vista and the 2007 Office System including SQL Server Analysis Services and Reporting Services improvements for Office 2007; increased interoperability; and enhanced manageability and data compression.

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

SQL Server 2005 Service Pack 2 Press Release Here:

http://www.microsoft.com/presspass/press/2007/feb07/02-19SQLSP2PR.mspx

What’s New In SQL Server 2005 Service Pack 2

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

A List Of The Bugs That Have Been Fixed In SQL Server 2005 Service Pack 2

This article contains information about the bugs fixed in SQL Server 2005 SP2.  Please note: (1) other fixes that are not documented may be included in the service pack and (2) this list will be updated when more articles are released.

http://support.microsoft.com/default.aspx?scid=kb;en-us;921896

Documents

SQL Server Questions and Answers From The Latest Technet Magazine

Database Size, Mirroring, Marked Transactions and More…

http://www.microsoft.com/technet/technetmag/issues/2007/02/SQLQA/default.aspx

Case Study: Denmark Telecom Leader Slashes Costs with 6 Terabyte Data Warehouse on SQL Server 2005

http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=200154

Downloads

SQL Server 2005 Service Pack 2 – Related Downloads

SQL Server 2005 SP2

To update SQL Server 2005 with Service Pack 2, click the link below and download the files most appropriate for you.

Download SQL Server 2005 SP2

SQL Server 2005 Express Edition SP2 (February 2007)

Download SQL Server 2005 Express Edition SP2

Update For Books Online (February 2007)

Download an updated version of Books Online for Microsoft SQL Server 2005, the primary documentation for SQL Server 2005. The February 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.

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Samples and Sample Databases (February 2007)

The February 2007 release is compatible with SQL Server 2005 SP2. There are several new samples in this release, and many bug fixes. See the SQLServerDatabasesAndSamplesOverview.htm file included with this download for a description of the new samples available in this release.

http://www.microsoft.com/downloads/details.aspx?FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en

SQL Server 2005 Feature Pack (February 2007)

Download the SQL Server 2005 Feature Pack (February 2007)

Reporting Services Add-in for Microsoft SharePoint Technologies (February 2007)

SQL Server 2005 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of SQL Server 2005 SP2 report processing and management capabilities in SharePoint. The download provides a Report Viewer web part, web application pages, and support for using standard Windows SharePoint Services.

Download SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

Data Mining Add-ins for Microsoft Office 2007 (February 2007)

SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 allow you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes Table Analysis Tools for Excel, Data Mining Client for Excel, and Data Mining Templates for Visio.

Download SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007

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.

http://www.microsoft.com/sql/eval/webcast.mspx?wt.mc_id=sql.ad.01037

SQL Server 2005 Service Pack 2 Webchat

Join the SQL Server 2005 development team to learn more and ask technical questions about the Service Pack 2 release made available for public download on 2/19/2007.

Add to Calendar

Microsoft Webcast: Selecting the Right SQL Server 2005 Edition to Fit Your Business (Level 200)

Microsoft SQL Server 2005 is a collection of components, and each component has a number of features to support various aspects of a database application. Microsoft has packaged these components and features into various editions to better accommodate the system availability, performance, and price requirements of different customers. Before you acquire and install SQL Server 2005, attend this webcast to compare editions and find the best match for your application and business needs. We explore the key differences between SQL Server 2005 Enterprise and Standard editions in the areas of availability, scalability, manageability, and business intelligence (BI) to help you determine which edition is right for you.

Thursday, March 8, 2007

11:00 A.M.–12:00 P.M. Pacific Time
Microsoft Webcast: Selecting the Right SQL Server 2005 Edition to Fit Your Business (Level 200)

TechNet Webcast: SQL Server 2005 SP2 Tools and Improvements (Level 200) 

In this webcast, we discuss the broad range of tools available for Microsoft SQL Server 2005 Service Pack 2 (SP2). If you are a database administrator or IT professional who is new to SQL Server 2005 or would like to see a few of the great scenarios enabled by SP2, you should attend this session. We cover several tools and features that are new or improved in SP2, including Management Studio, Best Practices Analyzer, multi-instance maintenance plans, custom reports, script generation, and the Copy Database Wizard.

Tuesday, March 20, 2007

1:00 P.M.–2:00 P.M. Pacific Time
TechNet Webcast: SQL Server 2005 SP2 Tools and Improvements (Level 200)

MSDN Webcast: Building Data-Driven Web Applications with SQL Server Express (Part 1 of 3) (Level 200)

Join this three-part webcast series as we highlight graphical techniques for building Web sites that create data-bound solutions with Microsoft SQL Server 2005 Express Edition and Visual Web Developer 2005 Express Edition. In this first presentation, we focus on creating Web sites that use the new Microsoft ASP.NET login controls. Be sure to attend the second installment of our series to learn techniques for displaying and manipulating data from ASP.NET controls on Web pages. In the third part our series, we describe using a single middle-tier data object on multiple Web pages, in addition to master page and site navigation techniques.
Thursday, March 1, 2007

1:00 P.M.–2:00 P.M. Pacific Time

MSDN Webcast: Building Data-Driven Web Applications with SQL Server Express (Part 1 of 3) (Level 200)

TechNet Webcast: Introduction to SQL Server 2005 Integration Services (Level 200)

Microsoft SQL Server 2005 Integration Services is a completely redesigned, feature-rich, enterprise data integration platform. In this session, we introduce you to the enterprise-class capabilities of Integration Services, including dedicated management functionality, collaborative development environment, and high scalability and reliability. Also, learn how you can use SQL Server 2005 Integration Services to implement data quality, data profiling, and custom transforms in your organization.

Monday, March 5, 2007

1:00 P.M.–2:30 P.M. Pacific Time

TechNet Webcast: Introduction to SQL Server 2005 Integration Services (Level 200)

TechNet Webcast: Measuring the Security Quality of SQL Server 2005 and the Security Development Lifecycle (Level 200)

Every vulnerability in a database infrastructure means attacks are that much more likely to succeed. With that in mind, the Enterprise Strategy Group (ESG) compiled data to compare security vulnerabilities in Microsoft SQL Server 2005, the first Microsoft product to run through the Security Development Lifecycle (SDL), with those in competing products. Join this webcast as we review the highlights of the SDL, illustrate the process of quantifying security quality, and explain what you can learn from the experiences that Microsoft had.

Thursday, March 8, 2007

1:00 P.M.–2:00 P.M. Pacific Time

TechNet Webcast: Measuring the Security Quality of SQL Server 2005 and the Security Development Lifecycle (Level 200)

TechNet Webcast: Introducing a New Storage Format for Decimal and Numeric Data in SQL Server 2005 (Level 200)

Do you have an application that depends on a Microsoft SQL Server 2005 database? Are there tables in that database with columns that contain decimal values? If so, you may be able to reduce the size of those tables, and thereby reduce the size of the database. This webcast provides the details you need to use a new, more efficient storage format for decimal and numeric data. We also discuss the database size reduction you can expect, and the effect this may have on the performance of your applications.

Wednesday, March 28, 2007

1:00 P.M.–2:00 P.M. Pacific Time

TechNet Webcast: Introducing a New Storage Format for Decimal and Numeric Data in SQL Server 2005 (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

FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement

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

SQL Server 2005 Standard Edition

How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005

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

SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies

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

BUG: Error message when you use Database Mail in SQL Server 2005: "Error 14667, Severity 16, State 1"

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

FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005

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

You may be prompted to enter the old password when you try to reset the password of a SQL Server login by using a SQL Server login that is a member of the securityadmin fixed server role in SQL Server 2005

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

FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005

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

How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007

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

The remote instance of SQL Server 2000 does not stop when you use SQL Server Management Studio on the server that is running SQL Server 2005

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

Error message when you try to configure SQL Server Agent to interact with Database Mail in SQL Server 2005 64-bit editions: "An attempt was made to send an email when no email session has been established"

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

FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390

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

FIX: Error message when you use the Bcp.exe utility to import data into a table from a text file in SQL Server 2005: "The memory could not be written"

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

FIX: Some rows in the Text Data column are always displayed for a trace that you create by using SQL Server Profiler in SQL Server 2005

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

FIX: Error message when you use SQL Server 2005: "High priority system task thread Operating system error Exception 0xAE encountered"

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

FIX: I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005

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

FIX: SQL Server Profiler stops monitoring the instance after a time when you use SQL Server Profiler to monitor an instance of SQL Server 2005 Analysis Services

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

FIX: Some search results are missing when you perform a full-text search operation on a Windows SharePoint Services 2.0 site after you upgrade to SQL Server 2005

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

SQL Server 2005 Enterprise Edition

FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005

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

FIX: A "17187" error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load

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

BUG: You may receive incorrect results when you run a query against the target partitioned table after you insert data from a partitioned table to another partitioned table in SQL Server 2005

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

SQL Server 2005 Analysis Services

FIX: You may receive unexpected results when you run an MDX query in SQL Server 2005 Analysis Services

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

FIX: The query runs much slower than you expect when you use the InStr function in a calculated member of an MDX query in SQL Server 2005 Analysis Services

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

You may unexpectedly receive a NULL value when you run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services

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

You may experience decreased performance when you run queries against a cube that contains linked dimensions in SQL Server 2005 Analysis Services

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

FIX: Error message when you run a Multidimensional Expressions (MDX) query that uses a calculated member in SQL Server 2005 Analysis Services: "Internal error An unexpected exception occurred"

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

FIX: You may receive incorrect results when you run a Multidimensional Expressions (MDX) query that involves a calculated member and the autoexist functionality in SQL Server 2005 Analysis Services

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

FIX: Unfiltered results may be generated when you use a drillthrough action on a dimension that is stored in the ROLAP storage mode in SQL Server 2005 Analysis Services

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

FIX: The MDX query may never finish when you run the MDX query against a parent/child dimension in SQL Server 2005 Analysis Services

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

SQL Server 2005 Reporting Services

FIX: You may receive "UnavailableException" and "LogonFailedException" error messages when you perform a stress test on the report server in SQL Server 2005 Reporting Services

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

FIX: Error message when you open a report in Report Manager in SQL Server 2005 Reporting Services: "An error has occurred during report processing. There is already an open DataReader associated with this Command which must be closed first"

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

FIX: SQL Server 2005 Reporting Services cannot generate an error message in a report when the data source of the report calls a stored procedure that contains the RAISERROR statement

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

FIX: You cannot select a multivalued parameter from a drop-down list when you view a report in  Report Manager in SQL Server 2005 Reporting Services

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

FIX: The Report Server Windows service may stop responding, and you may receive the following error message in SQL Server 2005 Reporting Services: "An internal error occurred on the report server"

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

FIX: Error message when you use Report Builder after you install SQL Server 2005 Reporting Services SP1: "Short time pattern does not include hours and minutes"

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