>>>>>>>>>>Hi,
>>>>>>>>>>Did you consider the CE edition. That will run with embedded .NET DLLs only - but it's not multi-user.......
>>>>>>>>>__
>>>>>>>>>
>>>>>>>>>Viv,
>>>>>>>>>
>>>>>>>>>I'll have a look at it - no Date type though
>>>>>>>>
>>>>>>>>Sure there is
>>>>>>>__
>>>>>>>
>>>>>>>You're sure you're not talking about sql server 2008 ?
>>>>>>>
>>>>>>>

>>>>>>>&& bol Compact 3.5 sp1
>>>>>>>
>>>>>>>date
>>>>>>> nchar(10) value of the form 'YYYY-MM-DD'
>>>>>>>
>>>>>>>Note:
>>>>>>>SQL Server Compact stores wide characters. Conversion support for this type was provided by the SQL Server Compact 3.5 SP1 release.
>>>>>>>

>>>>>>
>>>>>>Already there in the 2000 edition:
>>>>>>http://technet.microsoft.com/en-us/library/aa237918(SQL.80).aspx
>>>>>__
>>>>>
>>>>>DateTime type, yes. Date type, no
>>>>>
>>>>>I've got the compact 3.5 sp1 installed on my system. When I add a field to a table, there's no 'date' type
>>>>>
>>>>>Which version do you have ?
>>>>Sorry. I assumed you meant DateTime. No version of MS SQL has a 'Date' datatype.
>>>______________
>>>
>>>Sql server 2008 has a Date type http://technet.microsoft.com/en-us/library/bb630352.aspx
>>
>>So it does. Naomi pointed it out and I, not concentrated, replies to her thinking it was you.
>>IAC, at the end of the day, you have what you need - a Date datatype in SQL CE ?
>>Regards,
>>Viv
>__
>
>No, the compact edition does not have a date type as far as I can see

OK. Guess we finally got there. SQL2008 Express has the Date datatype ; SQL2008 CE does not.
TBH, I'm not sure what advantage there is in the Date datatype - unless you're dealing with very large databases?
And DateTime gives you the ability to get changes to a table in the order in which they were made