Upgrading your database environment from SQL Server 2000 to SQL Server 2005 can present many challenges. Many of the new release's features fundamentally alter the mechanics of how database professionals interact with SQL Server; other features will have a long-term effect on how developers build database applications and the demands those applications put on DBAs. But regardless of the changes you expect, you want to be sure that after your upgrade, you're ready to take full advantage of the power and functionality that SQL Server 2005 provides.

Mic...