Sql Server 2008 CTP
You can download it from here.
I’ll have to download this and take a spin.
Two things I’ve read about that sound neat off the bat :
(1) Automatic auditing : one of my recent posts detailed how to do this. As I said, I end up doing this on practically every project, so it’s nice Microsoft is baking this right in.
(2) Date only and Time only datatypes : HALLELUJAH! I can’t tell you how many times this has screwed me when doing date comparison, and all I’m concerned with is a date, but the time element throws it off.