Q:

Error 242 in SQL Server Management Studio Express

Why when I try to insert this date in a "datetime" value a message 242 compare?
2012-11-16 00:00:00.000

This error there isn't if, for example I try to insert:
2012-11-16 15:00:00.000

A:

Insert it as '2012-11-16T00:00:00.000'
if you don't need the time, insert it as
'20121116'

Those are the ISO formats for datetime/date respectively. 
As with all other formats, you get problems depending on the language of the user that the SQL statement runs at. 
You can also get problems like that with months/days, and it's not always apparent. 
e.g. if you parse a string like '01/01/2015', it will always work. 
But when you get to '01/13/2015', you run into problems, because English uses month/day/year, while for example German uses day/month/year, and 13 is not a valid month... 
In your case, it's somehow misinterpreting time, and that can lead to all kinds of strange errors.

