title: Is there any difference between SQL Server r2 backward compatibility msi VS downloaded sql server 2005 backward compatibility msi?
body: <p>I freshly installed sql server 2008 r2 with selected option to install backward compatibility (add remove programs shows backward compatibility is installed)
  Then I run my sql script to upgrade the old database but it thrown exception like "The query uses non ANSI outer join" (see image for exact error). 
  (SQL profiler said: SQLDMO_1 throwing the error).</p>
  
  <p><img src="https://i.stack.imgur.com/j7GvV.jpg" alt="enter image description here"></p>
  
  <p>But when I installed SQLServer backward compatibility (SQLServer2005_BC.msi  downloaded from site) explicitly and did the same upgradation, its worked successfully.</p>
  
  <p>I don't know why its happening?</p>
  
  <p>I compared both SQLDMO.DLLs (Sql servere installation one and SQL server one), but both seems fine. 
  Did any one get same kind issue or any suggestion?</p>
  
  <p>UPDATE:
  No it was not an issue related to install backward compatibility. Recently same error occurred and I thought it would be solved by installing the bakward compatible msi but it does not solved. </p>
  
  <p>So still the reason is in suspense.</p>