There has some good amount of discussion going on in SQL Server community about should we upgrade from SQL Server 2000 to SQL Server 2005 or wait for SQL Server 2008. I have received quite a few email and invitations to participate in forums on this topic. Instead of talking about this topic on different places, I have decided to write my opinion on my blog.
I recommend to upgrade to SQL Server 2000 users to SQL Server 2005.
SQL Server 2008 is due next year. The RTM may or may not be available till February 2008. After the release the first service pack will be available after few months. This means that stable version will not be available till late 2008. SQL Server 2005 is perfectly has stable version and already two SP are released. This makes SQL Server 2005 very reliable product.
I suggest that SQL Server 2005 with Service Pack 2 installed is good upgrade from SQL Server 2000.
Reference : Pinal Dave (https://blog.sqlauthority.com)