SQL Server Q&A

Symptoms
Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release.
Resolution
Consider the following scenario:You drop a column of a partitioned table in SQL Server 2008 R2.You create a new partition for the table. You try to insert data into the new partition of the table.In this scenario, an access violation may occur.

Symptoms
In Microsoft SQL Server 2008, when you click the View Single Column Profile By Column buttonin the Data Profile Viewer (DataProfileViewer.exe), you receive the following error message:

Unhandled Exception
Resolution
The fix for this issue was first released in Cumulative Update 1. For more information about how to obtain this cumulative update package for SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:
956717?(http://support.microsoft.com/kb/956717/) Cumulative update package 1 for SQL Server 2008Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
956909?(http://support.microsoft.com/kb/956909/) The SQL Server 2008 builds that were released after SQL Server 2008 was released

Symptoms
When you try to run Microsoft SQL Server 2008 database engine repair from a DVD, the repair fails. Additionally, you may receive the following error messages.
Error message 1

MSI (s) (B0:B8) [13:10:17:779]: Note: 1: 1729 MSI (s) (B0:B8) [13:10:17:779]: Product: Microsoft SQL Server 2008 Database Engine Services — Configuration failed.
Error message 2

MSI (s) (B0:B8) [13:10:17:779]: Windows Installer reconfigured the product. Product Name: Microsoft SQL Server 2008 Database Engine Services. Product Version: 10.0.1600.22. Product Language: 1033. Reconfiguration success or error status: 1602.
Resolution
The fix for this issue was first released in Cumulative Update 1. For more information about how to obtain this cumulative update package for SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:
956717?(http://support.microsoft.com/kb/956717/) Cumulative update package 1 for SQL Server 2008Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
956909?(http://support.microsoft.com/kb/956909/) The SQL Server 2008 builds that were released after SQL Server 2008 was released