If you’re looking to upgrade you SQL Server, you may want to look into the following tools – the Best Practices Analyzer & the Upgrade Advisor – in preparation for the upgrade.
- SQL Server 2000 Best Practices Analyzer
http://www.microsoft.com/downloads/
en/details.aspx?FamilyID=b352eb1f-d3ca-44ee-893e-9e07339c1f22&displaylang=en - SQL Server 2005 Best Practices Analyzer (August 2008)
http://www.microsoft.com/downloads/
en/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en - SQL Server® 2008 R2 Best Practices Analyzer
(Works for both SQL Server 2008 & SQL Server 2008 R2)
http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591 - SQL Server 2005 Upgrade Advisor
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75 - SQL Server 2008 Upgrade Advisor
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852 - SQL Server 2008 SP2 Upgrade Advisor
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=bdd888fa-779f-480c-a85f-7d70b179e3b9
——————
For questions:
- SQL Server Setup & Upgrade Online Forum
http://go.microsoft.com/fwlink/?LinkID=123371
kurtsh
Kurt Shintaku's Blog 