That's right! cuz you can I think install named instance and not choose default for even very first installation.

Here's how it went:

I installed SQL 2008 on the same box that has 2005 and SQL 2008 cannot be the default instance. The default instance is called "MSSQLSERVER" which was...

Thanks All for the info. I'm planning the installation for next week and come back here if I encounter any issues...

Thanks sam.alexander for uploading the doc... this is indeed a nice document that can be followed as a baseline for the upgrade.

I'm surprised there's no utility to do the DTS to SSIS conversion? So I really have to re-write the SSIS packages? 🙁

Also the new SQL server 2008 server is going...

Thanks iamthemanx, yes, it will be joint effort various groups including developers so l'm sure I won't have to deal much with the application code. I can imagine finding issues...