Microsoft KB Archive/905693

= Additions to the Readme file for the SQL Server 2005 Upgrade Advisor tool =

Article ID: 905693

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Standard X64 Edition
 * Microsoft SQL Server 2005 Enterprise X64 Edition

-



SUMMARY
This article describes late-breaking changes for the current version of Microsoft SQL Server 2005 Upgrade Advisor. These changes are not included in the product documentation or Readme files. To download the SQL Server 2005 Upgrade Advisor, visit the following Microsoft Web site:

http://go.microsoft.com/fwlink/?LinkId=45788



MORE INFORMATION
Upgrading an instance of the Microsoft SQL Server 2000 Database Engine to SQL Server 2005 retains the configuration value for the max worker threads option. However, we recommend that you change the max worker threads value to 0 before you upgrade. This change enables the Database Engine to calculate the optimal number of threads. For more information, see the &quot;max worker threads Option&quot; topic in SQL Server Books Online.

Analyzing trace files
To analyze SQL Server 2000 trace files, use the SQLProfilerTSQL_Replay template when you create trace files. This template captures events that are required for replaying trace files. For more information, see the &quot;Replaying Traces&quot; topic in SQL Server 2000 Books Online.

Note SQL Server 7.0 trace files are not analyzed by Upgrade Advisor.

Use of isql.exe is not detected
The isql utility has been discontinued in SQL Server 2005. However, Upgrade Advisor does not detect the use of isql.exe in scripts or procedures. If you are using isql.exe, update your scripts or procedures to use sqlcmd.exe instead. For more information, see the &quot;sqlcmd Utility&quot; topic in SQL Server 2005 Books Online.

Keywords: kbinfo kbtshoot kbsql2005setup KB905693

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.