Hi

I upgraded a lot of SQL 2000 to SQL 2005

1. Remember that the passwords in SQL 2005 are key sensitive - the connection string might need a chagne

2. You need to find all link servers to and from the instance

3. If you got DTS you need to migrate them to SSIS or move them to another SQL 2000

4. dont forget to run best practices (rebuild indexes online, update statistics, recompile objects)

5. You can minumize the down time if you use full and diff/log backups

Good luck!

Guy H