title: how to handle dates before 2000 through linked server in SQL Server 2012?
body: <p>I have linked server established from firebird database to SQL Server 2012 and looks like 
  when copying data the dates before 2000 year appears as 30-13-1899, why is that?
  anyway to go around this weird behavior? I copy data like this:</p>
  
  <pre><code>SELECT * into #temp FROM OPENQUERY ( [test] ,'select * from testtable' )
  </code></pre>
  
  <p>thanks</p>