Yesterday we shipped Microsoft SQL Server 2008 Standard Edition DVDs to all of our SOLIDWORKS Enterprise PDM customers. I personally did not see them but I have been told if you hold the up to the light they look rainbowy.
SQL Server 2005 will still be supported for the foreseeable future. Typically SOLIDWORKS drops support for Microsoft products after Microsoft itself drops support. Thus if you are not experiencing any lost revenue in waiting to upgrade, I recommend not upgrading “just because it is there”.
Look for some performance enhancements, better memory management, data compression and an easier UI after the upgrade.