I made this mistake when I was creating a new table in one of my databases today.

When setting a default for a DateTime column in a SQL Server database, you'll get the error, Error validating the default for column 'column name', if you try something like Now() as the default. That's because that is not a valid function. You need to use GetDate().