>Hi
>
>I'm currently using (getdate()) as the default value for my smalldatetime fields, how can I insert a blank date/time as a default instead?
>
>Regards
There is no blank date in SQL Server. Use NULL instead (or default date 1/1/1900).
If it's not broken, fix it until it is.
My Blog