Hi, This is great. We use the following constraint and sanitation before assignment on date only columns in SQL 2005:

check (dateAdd(dd, datediff(dd, 0, datetimeColumn), 0) = datetimeColumn)

I believe at least...