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.