• Cris:

    If you use the ISO format for dates (yyyymmdd), not the yyyy-mm-dd format, SQL Server is not vulnerable for myd or dmy dates.

    See CONVERT ISO 112 (or 12 for yymmdd) in BOL.

    SQL server accepts '20050323' (today, y=2005, m=03, d=23) either in Europe or USA.