title: Is there any way to disable automatic type coercion in SQL Server 2005/2008, from varchar to int (as an example)?
body: <p>If I have the following SQL:</p>
  
  <pre><code>INSERT INTO sometable (someintcolumn) VALUES ('1')
  </code></pre>
  
  <p>This will succeed, inserting the value 1.</p>
  
  <p>Is there any way I can ask SQL Server to please don't convert the types for me, permanently or temporarily, and instead fail the above SQL execution?</p>
  
  <p>We have a large import project that we'd like to fix all SQL's for, but that requires meticulously going through all SQL's and analyzing the data types of all columns. Since this is executed against test databases on our servers, we'd like to get our server to tell us when we've got the data types wrong.</p>