I will be upgrading our database server from SQL Server Service Pack 2 to Sercice Pack 3 to address some deadlock bugs / issues that where fixed in SP3.
Any gotchas that you have run into? From the documentation is sounds straight forward.
I'll be doing the upgrade first in a few isolated areas to get the kinks out and do regression testing before upgrading our *production* database server.
Our plans are to get to SQL Server 2000 by Q2 of 2002, but need the service pack fix now.