>Hi,
>
>Is it possible to specify default for DateTime column of SQL database? Ideally I would like the default to be the current date and time. Please let me know. TIA.

you can supply a constraint that sets the default to GETDATE()

You can do this in SSMS easily if you open the table in design mode and click on the column - there is a section for default.

Update - here's an example -- http://www.mssqltips.com/tip.asp?tip=1425