SQL Server Q&A

Symptoms
When running the Version Upgrade Wizard to upgrade SQL Server 6.x to SQL Server 7.0, if a database whose name is 30 characters long is excluded from the upgrade, the wizard generates an unhandled exception and stops running.
If Dr. Watson is set as the default debugger, an error message similar to the following will be displayed immediately after clicking the EXCLUDE button:

An application error has occurred
and an application error log is being generated.
upgrade.exe
Exception: privileged instruction (0xc0000065), Address: 0×007f1a80
Resolution
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in SQL Server 7.0 Service Pack 1. For more information, contact your primary support provider.

Symptoms
When you run the Index Tuning Wizard, this error message may occur:

Server: Msg 3628, Level 16, State 1, Line 2
A floating point exception occurred in the user process. Current transaction is canceled.
Resolution
When a double was out of range from an underflow or overflow, the Index Tuning Wizard incorrectly converted the number into the maximum or minimum float value.

Symptoms
Consider the following scenario. You install Microsoft SQL Server 2005 on a computer that has an Intel Pentium II processor. In SQL Server 2005, you run the SQL Server Import and Export Wizard. In this scenario, you receive the following error message:

SQL Server Import and Export Wizard has encountered a problem and needs to close. Sorry for the inconvenience.When you click OK, you receive the following error message:

Unhandled exception at 0×2357c258 in DTSWizard.exe: 0xc000001d: Illegal Instruction.
Resolution
This behavior occurs because the Pentium II processor is not supported by SQL Server 2005. The minimum CPU requirement for a SQL Server 2005 installation isa 600-megahertz (MHz)Pentium III-compatible processor.
During the SQL Server 2005 installation process, SQL Server 2005 determines whether the system meets the minimum software requirements and the minimum hardware requirements. Typically, you receive a warning on the System Configuration Check page of the SQL Server Installation Wizard if SQL Server 2005 finds any incompatibility. However, you do not receive a warning about the incompatible Pentium II processor, and the installation process continues. Therefore, you receive the error message that is mentioned in the “Symptoms” section when you run the SQL Server Import and Export Wizard.