Can't find microsoft.sqlserver.batchparser.dll

To get this dll, you will need to install the Microsoft SQL Server 2008 Management Objects (available from here). That particular dll gets installed into the GAC, which is why you probably cannot find it using a search.

As you are using a hosting provider, it would appear that they do not have this installed. Your choices are to get it installed by them (which is probably unlikely), or deploy the dll manually (which may be on dodgy licencing ground).


First you need to enable browsing of GAC folder:

1. go to Registry Editor (RUN > regedit)
2. go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion
3. Right click Fusion > NEW > DWORD
4. Type DisableCacheViewer
5. Double click DisableCacheViewer
6. Set value to 1

then you can find it here
C:\Windows\assembly\GAC_32\Microsoft.SqlServer.BatchParser\10.0.0.0__89845dcd8080cc91


I had a similar issue, but with R2. For me it worked by installing Microsoft® SQL Server® 2008 R2 Shared Management Objects and dependant Microsoft® System CLR Types for SQL Server® 2008 R2.

Find them here http://www.microsoft.com/en-us/download/confirmation.aspx?id=16978


You need to have the SMO components installed on your hosting provider as well. You can download them here.


I resolve this only Just Right Click on Project navigate to Properties and Change Platform Target from 'Any' to 'x86'

failed to load microsoft.sqlserver.batchparser