SP2 Preview of SQL Server 2008 R2 Released

Fixes based on user input; includes previous fixes as well.

`

Microsoft has made available a preview of its forthcoming Service Pack 2 (SP2) for SQL Server 2008 R2.

The release -- a community technology preview (CTP) -- is designed for testing purposes only; it should not be used in production environments. The preview is available for downloaded from .

Microsoft did not offer a final release date for the production version of the service pack.

SP2 corrects about two dozen flaws in the relational database management system. The flaws are described in this Knowledge Base article.

The fixes are based on requests from users, according to Microsoft's announcement. The CTP includes "hotfixes" from Microsoft's earlier release -- specifically, cumulative updates 1 through 5 for SQL Server 2008 R2 Service Pack 1.

Microsoft listed three highlights in the CTP. It's designed to fix an issue where charts in Windows 7 reports are inexplicably cropped. Another fix addresses a problem with "hidden rows," that causes rows or cells to collapse in reports. Finally, Microsoft added a fix to correct a caching problem associated with "batch files containing the alter table command," according to the company's announcement.

About the Author

Kurt Mackie is senior news producer for the 1105 Enterprise Computing Group.