Microsoft.SqlServer.BatchParserClient.dll not included in Microsoft SQL Server 2008 Management Objects
We are developing and testing against a SQL 2008 server. The required assembly Microsoft.SqlServer.BatchParserClient.dll is not included in the downloadable feature pack. I had to copy the DLL from a machine with SQL 2008 installed to the client machine. This assembly is not found after trying to use Database.ExecuteNonQuery Method. I believe this required assembly should be installed with the rest of the SMO assemblies.
Upvotes: 19<=-=Jul 15 2008 4:31AM=-=>
Thanks for reporting this issue. This issue is already fixed and will be available in next public release of Sql Server.
I had the same issue . I my case I installed the 32 bit version of SMO to windows 2003 server and it did not install Microsoft.SqlServer.BatchParserClient.dll which caused a problem during execution.<=-=Nov 24 2009 10:12AM=-=>
It may be fixed as far as the assembly cach install process for smo , but it is not fixed for creating
redistributable setup packages.
I have sql express advanced editions with sp1 and vs 2008 with sp1 installed. I have a Report Installer setup
package which uses an imbedded vb.net app as an execution event installer process. I ported this project to
2008. I had to update the vb.net smo refferences to sql 2008, and it did not calculate the neccessary dependency
for the BatchParserClient nor is there any such dll in the redistributable sdk available for setup packaging !!!
Please clarify how to resolve this issue for setup packages, thank you !!!<=-=Sep 14 2010 5:12AM=-=>
Hello, it’s september 2010 and we got bitten by this today !?
We’re using vs2010 and the sqlserver that comes with it. In the meantime windows has updated ss2008 to
sp1. But still, there is no BatchParserClient in the SDK folder that installed when installing SqlServer2008.
Who’s asleep at the wheel over there ?<=-=May 24 2011 9:39PM=-=>
STILL WAITING FOR THIS<=-=May 25 2011 11:11PM=-=>
When will this assembly be available?<=-=Dec 19 2011 11:19AM=-=>
When will this assembly be available? Which release of SQL Server … re: Microsoft 07/15/2008 “This issue is already fixed and will be available in next public release of Sql Server.”.
Wasn’t fixed in the Microsoft SQL Server 2010 release. Maybe release Microsoft SQL Server 2000 never?<=-=Jun 5 2012 8:31AM=-=>
This has been open since 2008! What is the fix? Is there a workaround?<=-=Jun 2 2015 5:25AM=-=>
Still an issue as of June 2015!
“This issue is already fixed and will be available in next public release of Sql Server.” – this helps not at all because the issue is with the redistributable you have provided for the 2008 and 2008R2 versions of SQL Server. These versions are still widely used today, and the redistributable is needed in order to deploy software using SMO to sites using these versions of SQL Server.<=-=Feb 4 2016 7:47AM=-=>
This is a workaround and certainly not a real fix, but I was able to find the proper DLL in C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.BatchParserClient\22.214.171.124…\Microsoft.SqlServer.BatchParserClient.dll.
If anyone knows why this wasn’t included automatically as part of the SMO assemblies, please let us know.