With our new server we installed SQL Server 2008 Standard.
I haven't even scratched the surface of it's features (SSIS, etc) but I LOVE the InteliSense that SQL Server 2008 has.
It is now painful to switch back to 2000 or even 2005 because I've gotten spoiled with 08's InteliSense.
OK.. I'll agree on the Intellisense.. But I'm not about to sell SQL 2008 to my clients based on the fact that it makes development work for me easier. Pretty much all of my clients are on 2005, unless they're stuck with applications that don't work in 2005 and have to stay with 2000 until their developers pull their thumbs out. (I've one or two like that, the most recent one was last weekend, had to do a quick U turn and downgrade again because their application developers had missed a trick!) But I'm upgrading users to 2005, and not 2008, even if the livcence allows them to go to 2008. I don't see the point in jumping into a new, untried product when 2005 is so stable, and there are no useful features in SQL 2008 Standard. 2005 is tried, tested, and stable, so unless MS bring out a service patch that releases some of the enterprise features into Standard, I'm not going down that road, there's no financial benifit to the client, which is where the buck stops.