Is it possible or has anyone had success with setting the "Default Value or Binding" to getdate() in SQL Management Studio to auto populate a date field with the current date/time?
Online resource