sql not null date field

so the datetime field in MS SQL is a special case. to add columns of this type with a NOT NULL attribute the following format is required.

alter table dbo.foo
add myDateField DATETIME default getdate() NOT NULL

alternatively, if you want to set your own default date , just replace the getDate() function with a string value such as ‘1900/01/01’.

fwiw,
– Pete