Conversion of a varchar data type to a datetime. Out-of-range error
<p>I have a strange error with my SQL Query.</p>

<p>This works:</p>

<pre><code>INSERT INTO tbl_SomeTable(Send_Type,Remote_Eml,Cover_Subj,Cover_Note,AtnId,StandortEinsatzValue,Standort,KundenNr,AtnTel,Name,Strasse,AtnName,AreaManagerContact,Datum,PLZOrt)
VALUES ('2', '', '', '','02832','1','Replaced','2001158207','Replaced','Real','Replaced','Replaced','Replaced','10.12.2016','15745 Replaced')
</code></pre>

<p>This gives me an error:</p>

<pre><code>INSERT INTO tbl_SomeTable(Send_Type,Remote_Eml,Cover_Subj,Cover_Note,AtnId,StandortEinsatzValue,Standort,KundenNr,AtnTel,Name,Strasse,AtnName,AreaManagerContact,Datum,PLZOrt)
VALUES ('2', '', '', '','02832','1','Replaced','2001158207','Replaced','Real','Replaced','Replaced','Replaced','17.12.2016','15745 Replaced')
</code></pre>

<blockquote>
  <p>The conversion of a varchar data type to a datetime data type resulted
  in an out-of-range value.</p>
</blockquote>

<p>Only difference is the date. "10.12.2016" vs "17.12.2016".
Column "Datum" is of type "datetime".</p>

<p>We use a SQL Server 2016.</p>

<p>Can you help me?</p>