title: Can't find microsoft.sqlserver.batchparser.dll
body: <p>I wrote an asp.net web app which uses SMO against SQL Server 2008 to be able to run some DB scripts. It references these assemblies (in the C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies folder):</p>
  
  <pre><code>Microsoft.SqlServer.ConnectionInfo
  Microsoft.SqlServer.Management.Sdk.Sfc
  Microsoft.SqlServer.Smo
  </code></pre>
  
  <p>The microsoft.sqlserver.batchparser.dll is not in this folder.
  Locally (32 bits machine, IIS7) I have no issue.</p>
  
  <p>When I publish the app to my hosting provider (discountasp.net, SQL Server 2008, IIS7, 32bits too), I get this error:</p>
  
  <blockquote>
    <p>Could not load file or assembly
    'Microsoft.SqlServer.BatchParser,
    Version=10.0.0.0, Culture=neutral,
    PublicKeyToken=89845dcd8080cc91' or
    one of its dependencies. The system
    cannot find the file specified.</p>
  </blockquote>
  
  <p>I searched my local machine and I can't find this assembly. However it works well on this machine.</p>
  
  <p>The "Microsoft SQL Server 2008 Setup Discovery Report" tool reports I have v10.1.2531.0 installed locally.</p>